oracle查询语句中 使用了union之后再Order by 出现的问题,在线等+————急———————————————————————— 如题如下语句:select a as c from xunionselect b as c from yorder by to_number(c)此时会报错,c不在select -list 中请教下该如何解决这个问题,在线等,急 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select c from(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 to_number()是什么啊 怎么用啊?指教一下啦 嘿嘿谢谢! 急!两个问题,求大神 关于行转列。。。 oracle CallableStatement ORACLE CLUSTERWARE 安装问题 oracle to_number 错误 start with connect by的排序的问题 请教个选择开发Oracle工具的问题 SQL语句对用* 与用表的字段对数据库系统的影响? 请问原买盗版碟Oracle 9i都三张碟,为什么我看见盗版市场的Oracle 10g却只有一张碟,并且买回来安装却可以用,但感觉安装后的程序-->菜单没 在触发器怎么引用pl\sql程序块? oracle 求优化SQL效率的思路和方法
(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