56,687
社区成员
发帖
与我相关
我的任务
分享
table a:
aid na nb
0 1 2
1 1 3
2 3 2
查询结果:
nab
1
2
3
select nab
from (
select distinct na as nab from a
union
select distinct nb as nab fromm a
)T
order by T.na
select nab
from (
select na as nab from a
union
select nb as nab fromm a
)T
order by T.nab