Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

(SQL)ÈçºÎµÃµ½×Ö¶ÎÖµÏàµÈµÄ¼Ç¼¼¯

(SQL)ÈçºÎµÃµ½×Ö¶ÎÖµÏàµÈµÄ¼Ç¼¼¯
group by
order by
¶¼²»¿ÉÒÔѽ
Where your_field = some_value

group by ..having

ÒýÓÃ
Where your_field = some_value

ÎÒµÄÒâ˼¡£¡£
±ÈÈ磺u_nameÊÇÒ»¸ö×ֶΣ¬µÃµ½ËùÓÐÓÐu_nameÒ»ÑùµÄ¼Ç¼¼¯£¡

±í´ï²»Çå,Çë¾Ù¸öÀý×Ó

×îÆðÂëÐèÒª¸øÒ»¸öÆ¥ÅäµÄÌõ¼þÖµ°É
eg. Name=@Name

˵¸öÀý×ÓÂï.ÕâÑù±í´ï²»ÊǺÜÇå³þ¹þ.

select * from TB where u_name in (select u_name from TB group by u_name HAVEING count(u_name)>1)

ÓÑÇéUP````````````````

ÒýÓÃ
select * from TB where u_name in (select u_name from TB group by u_name HAVEING count(u_name)>1)

Õâ²ÅÊǸßÊÖ

Óкܶ෽·¨£¬·´Õý¶¼ÊÇʹÓÃsqlÓï¾ä£¬Â¥Ö÷¿´¿´Õâ¸ö£¬ÓйØSQLÓï¾ä½éÉܵÄÊ飬ºÜʵÓãº
http://download.csdn.net/source/1644211

лл¡¢¡¢¡¢¡¢¡¢¡¢¡¢ ÎÒÏÂÔØÁË


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ