我能想到的最笨的办法就是:select 'a' from dual union select 'b' from dual union select 'c' from dual minus select id from tab;还能有什么别的方法么?
select * from ( select (case when 'a' not in (select a from qxjtest) then 'a' end) as a, (case when 'b' not in (select a from qxjtest) then 'b' end) as b, (case when 'c' not in (select a from qxjtest) then 'c' end) as c from dual ) a;
select * from
(
select
(case when 'a' not in (select a from qxjtest) then 'a' end) as a,
(case when 'b' not in (select a from qxjtest) then 'b' end) as b,
(case when 'c' not in (select a from qxjtest) then 'c' end) as c
from dual
) a;