34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>0 AND sv.number<10
EXCEPT
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>0 AND sv.number<5
/*
number
5
6
7
8
9
*/
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>0 AND sv.number<10
INTERSECT
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>0 AND sv.number<3
/*
number
1
2
*/
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>0 AND sv.number<3
UNION
SELECT sv.number FROM MASTER.dbo.spt_values AS sv WHERE sv.[type]='P' AND sv.number>5 AND sv.number<10
/*
number
1
2
6
7
8
9
*/