17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> with m as (
2 select 1 a,1 b from dual union all
3 select 1,2 from dual union all
4 select 1,3 from dual union all
5 select 2,1 from dual union all
6 select 2,2 from dual union all
7 select 2,3 from dual union all
8 select 3,1 from dual union all
9 select 3,2 from dual union all
10 select 3,3 from dual
11 )
12 select distinct least(a,b) a,greatest(a,b) b
13 from m
14 where a <> b
15 order by 1,2;
A B
---------- ----------
1 2
1 3
2 3
SQL>