Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

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

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

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ