Çë½ÌÒ»¸öSQL²éѯµÄд·¨ - MS-SQL Server / »ù´¡Àà

ÀàËÆÏÂÃæµÄ´úÂëÖ´ÐÐʱ¼ä·Ç³£³¤£¬ÇëÎÊÒªÔõÑùд²ÅÊÇÕýÈ·µÄд·¨£¿


select * from a where a.×Ö¶Î1+a.×Ö¶Î2 not in (select b.×Ö¶Î1+b.×Ö¶Î2 from b) 

(ʵ¼ÊÉϵÄÓ¦ÓÃÇé¿öÊǸü¶à×ֶΣ¬¸ü¶àµÄ×Ó²éѯ£¬µ«Ö¢½á¾ÍÊÇÂýÔÚ¶à×ֶεÄINÉÏÃ棬ÆäÓàµÄ¶¼·Ç³£¿ì£¬Î¨Ò»ÊÇÓõ½
a.×Ö¶Î1+a.×Ö¶Î2 not in µÄ¾äʱ£¬¾Í¼«Âý£¡

Ïò¸÷λ¸ßÊÖÇóÖú£¡

---

»»not exists ÊÔÊÔ

---

ÒýÓÃ

SQL code
select * from a inner join b
on a.×Ö¶Î1+a.×Ö¶Î2 =b.×Ö¶Î1+b.×Ö¶Î2
where b.×Ö¶Î1 is null

ÕâÖÖд·¨¿´²»¶®£¿ÄÜÕâÑùд£¿

---

ÒýÓÃ

»»not exists ÊÔÊÔ

×ֶθöÊý²¢²»ÊÇÒ»ÑùµÄ£¬ÇëÎÊÈçºÎд¡£

---

SQL code:
select * from a inner join b
on checksum(a.×Ö¶Î1,....)=checksum(b.×Ö¶Î1,....)
where b.×Ö¶Î1 is null

---

ÒýÓÃ

ÒýÓà 2 Â¥ chuifengde µÄ»Ø¸´:
SQL code
select * from a inner join b
on a.×Ö¶Î1+a.×Ö¶Î2 =b.×Ö¶Î1+b.×Ö¶Î2
where b.×Ö¶Î1 is null

ÕâÖÖд·¨¿´²»¶®£¿ÄÜÕâÑùд£¿

2Â¥ºÍ5Â¥¶¼Îó°ÑLEFT JOINд³ÉÁËINNER JOIN¡£

---

ÒýÓÃ

SQL code
select * from a inner join b
on checksum(a.×Ö¶Î1,....)=checksum(b.×Ö¶Î1,....)
where b.×Ö¶Î1 is null

ʲô´úÂë°¡£¬ÕâÑùдÔõôÐУ¿
{{----