如题
如下语句:
select a as c from xunionselect b as c from yorder by to_number(c)此时会报错,c不在select -list 中请教下该如何解决这个问题,在线等,急
如下语句:
select a as c from xunionselect b as c from yorder by to_number(c)此时会报错,c不在select -list 中请教下该如何解决这个问题,在线等,急
(select a as c from xunionselect b as c from y
)order by to_number(c)
--你写的是别名
select c from
(select a as c from xunionselect b as c from y)
order by to_number(c)
有规律的话可以这样
select a as c from xunionselect b as c from yorder by 1