Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

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

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

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

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

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ