如何对oracle中select并order出的数据集自动加入1、2、……序号? select rownum,t.* from tbTemp t order by name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可是我还分了组,提示rownum不是group by 表达式我整体的语句应该是select sum(pax) as total from sell group by agentid order by total desc 然后我想对每条记录添加排序号 这样可以实现吗? select rownum,T.total from (select sum(pax) as total from sell group by agentid order by total desc) T 在Oracle8i中:select rownum,a.total from (select sum(pax) as total from sell group by agentid order by total desc) a 修改如下:select rownum id,a.total from (select sum(pax) as total from sell group by agentid order by total desc) a 在使用select rownum id,a.total from (select sum(pax) as total from sell order by total ) a 出现"error:ora_00907 missing right parenthesis"提示,不知为何? 求助!!各位大侠,帮忙看看查询速度好慢 PC编译问题:ld: Unsatisfied symbol "sqlcxt" in file xxxx --登陆问题?-- sql 问题 急救!一个oracle 的存储过程问题 ————在线等 写oracle function 时,怎样跳出loop? 求sql语句 SQl语句的查询问题 ORACLE中的一个简单问题,初学者 有不有什么办法在EXP的同时,把脚本给生成出来。 請教各位高手一個很基本的問題 如何检查表空间信息
select sum(pax) as total from sell group by agentid order by total desc
然后我想对每条记录添加排序号
这样可以实现吗?
from (select sum(pax) as total from sell group by agentid order by total desc) a
from (select sum(pax) as total from sell group by agentid order by total desc) a
from (select sum(pax) as total from sell order by total ) a 出现"error:ora_00907 missing right parenthesis"提示,不知为何?