17,086
社区成员
发帖
与我相关
我的任务
分享
select * from tb1 t1 where ...
minus
select * from tb1 t2 where ...
-- 表示:在查询一中存在,而在查询二中不存在的数据集合!
-- 别想那么多:巧用 minus 关键字!
SELECT *
FROM (SELECT *
FROM TEMP_SHORTNUM_CDR_D A
MINUS
SELECT T1.*
FROM DM.TEMP_SHORTNUM_CDR_D T1, DMCODE.DIM_PLATFORM_TYPE T2
WHERE T1.OPPO_NUMBER_N LIKE T2.PLATFORM_ID || '%')
SELECT *
FROM TEMP_SHORTNUM_CDR_D A
SELECT T1.*
FROM DM.TEMP_SHORTNUM_CDR_D T1, DMCODE.DIM_PLATFORM_TYPE T2
WHERE T1.OPPO_NUMBER_N LIKE T2.PLATFORM_ID || '%'
有8019行。with b as ( select ... 你要得到 的结果集的SQL语句 )
select * from a
minus
select * from b;
--比如A、B表各3个字段col,col2,col3
select *
from A a
where not exists
(select 1 from B b where b.col1=a.col1 and b.col2=a.col2 and b.col3=a.col3) --真实表有几个字段就写几个