By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with AAA as
(
select 'aaa' as str from dual union all
select 'aaa' from dual union all
select 'aaa' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual
), BBB as
(
select 'aaa' as str from dual union all
select 'aaa' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual
), t as
(
select row_number() over (order by 1) rn, str from BBB
minus
select row_number() over (order by 1) rn, str from AAA
)
select str
from t
| STR |
|---|
| bbb |
with AAA as
(
select 'aaa' as str from dual union all
select 'aaa' from dual union all
select 'aaa' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual
), BBB as
(
select 'aaa' as str from dual union all
select 'aaa' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual union all
select 'bbb' from dual
), t as
(
select row_number() over (order by 1) rn, str from AAA
minus
select row_number() over (order by 1) rn, str from BBB
)
select str
from t
| STR |
|---|
| aaa |