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

Õâ¸öSQL Ôõôд - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÒ»¸ö±í´ó¸Å½á¹¹ÈçÏ£º
 ÉÌÆ·±àºÅ ÉÌÆ·Ãû ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5

Èç¹û£º ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 ÕâÎå¸ö×Ö¶ÎÒ»ÑùµÄ»° È¡ ÉÌÆ·±àºÅ×îСµÄ¼Ç¼ ÎÊÎʸÃÔõôд£¿

SQL code:
SELECT *
from TB AS T
WHERE NOT EXISTS(SELECT * from TB
WHERE ÉÌÆ·±àºÅ<T.ÉÌÆ·±àºÅ
AND ·ÖÀàÒ»=T.·ÖÀàÒ»
AND ·ÖÀà2=T.·ÖÀà2
AND ·ÖÀàÈý=T.·ÖÀàÈý
AND ·ÖÀàËÄ=T.·ÖÀàËÄ
AND ·ÖÀà5=T.·ÖÀà5 )


ÎÒÊÔÊÔ

ÒýÓÃ
ÏÖÔÚÓÐÒ»¸ö±í´ó¸Å½á¹¹ÈçÏ£º
ÉÌÆ·±àºÅ ÉÌÆ·Ãû ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5

Èç¹û£º ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 ÕâÎå¸ö×Ö¶ÎÒ»ÑùµÄ»° È¡ ÉÌÆ·±àºÅ×îСµÄ¼Ç¼ ÎÊÎʸÃÔõôд£¿

 ºÃÓÃ


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

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

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

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

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

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ