590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a TABLE (id INT,c2 NVARCHAR(20))
DECLARE @b TABLE (id INT,c2 NVARCHAR(20))
INSERT INTO @a VALUES (1,'北京')
INSERT INTO @a VALUES (2,'上海')
INSERT INTO @b VALUES (1,'北京')
INSERT INTO @b VALUES (2,'上海')
INSERT INTO @b VALUES (3,'湖北')
--方法1
SELECT * FROM @b WHERE c2 NOT IN (
SELECT c2 FROM @a
)
--方法2
SELECT * FROM @b b WHERE NOT EXISTS (
SELECT 1 FROM @a a WHERE a.c2=b.c2
)
--方法3
SELECT * FROM @b
EXCEPT
SELECT * FROM @a