34,594
社区成员
发帖
与我相关
我的任务
分享
DECLARE @i TABLE(id INT)
INSERT INTO @i
select 1
union
select 3
select * from (
select 1 AS id
union
select 3 AS id
union
select 6 AS id
union
select 7 AS id)A
except
select id from @i where id in (1,3,6,7)
/*
6
7*/
;WITH cte AS
(SELECT id = ROW_NUMBER() OVER(ORDER BY GETDATE()) FROM sys.columns a, sys.columns b)
SELECT *
FROM cte a
LEFT JOIN tb b
ON a.id = b.id
WHERE rowno IN(1,3,6,7)
select * from (select 1 as id union select 3 union select 6 union select 7) a
left join 表a b on a.id=b.id