Õâ¸ö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 ÕâÎå¸ö×Ö¶ÎÒ»ÑùµÄ»° È¡ ÉÌÆ·±àºÅ×îСµÄ¼Ç¼ ÎÊÎʸÃÔõôд£¿ ºÃÓÃ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏ ±íÃû: hisdata ×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä Id value state dattime 101 32.3 0 ......