(SQL)ÈçºÎµÃµ½×Ö¶ÎÖµÏàµÈµÄ¼Ç¼¼¯ group by order by ¶¼²»¿ÉÒÔѽWhere your_field = some_value group by ..having ÎÒµÄÒâ˼¡£¡£ ±ÈÈ磺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```````````````` Õâ²ÅÊǸßÊÖ Óкܶ෽·¨£¬·´Õý¶¼ÊÇʹÓÃsqlÓï¾ä£¬Â¥Ö÷¿´¿´Õâ¸ö£¬ÓйØSQLÓï¾ä½éÉܵÄÊ飬ºÜʵÓ㺠http://download.csdn.net/source/1644211 лл¡¢¡¢¡¢¡¢¡¢¡¢¡¢ ÎÒÏÂÔØÁË