sqlÓï¾ä¡£¡£ - MS-SQL Server / »ù´¡Àà
ÏÖÓÐA B Á½±í A±í¼Ç¼Èç name no times date ÕÅÈý 002 1 2008-12-01 ÕÅÈý 002 2 2008-12-22 ÕÅÈý 002 3 2009-12-01 ÀîËÄ 010 1 2005-01-01 ÍõÎå 022 2 2004-01-23 B±í¼Ç¼Èç name no times date ÕÅÈý 002 1 2008-12-01 ÕÅÈý 002 2 2008-12-22 ÕÅÈý 002 3 2009-12-01 ÕÅÈý 002 4 2010-12-01 ÕÅÈý 002 5 2010-12-22 ÕÅÈý 002 5 2010-12-29 £¨´ÎÊýÒ»Ñù£¬ÈÕÆÚ²»Ò»Ñù£© ÀîËÄ 010 2 2005-12-23 ÍõÎå 022 4 2007-01-23 ÍõÎå 022 5 2007-01-25 ÎÒÒª²é³öB±íÀïA±íûÓеļǼ¡£¡£¡£Õâ¸öSQLÔõôд°¡¡£¡£
select * from b where not exists( select 1 from a where a.name=b.name and a.no=b.no and a.times=b.times and a.date=b.date) SELECT * from B EXCEPT SELECT * from A; SQL code: select * from tb except select * from ta SQL code: select * from b where not exists(select 1 from a where name=b.name and no=a.no and times=a.times and [date]=t.[date])ÒýÓÃ SQL code -----------------------------------
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......