(SELECT * FROM CUX3_HDSP_VAT_HEADER)
except
(SELECT * FROM DUMP_CUX3_HEADER)
执行如上语句后报'在关键字 'except' 附近有语法错误。',
还请大神们指导下SQL SERVER中类似于oracle中的insect,minus,except的函数使用方法,谢谢
except
(SELECT * FROM DUMP_CUX3_HEADER)
执行如上语句后报'在关键字 'except' 附近有语法错误。',
还请大神们指导下SQL SERVER中类似于oracle中的insect,minus,except的函数使用方法,谢谢
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
*/