如何取统计后的前10条记录 select * from (select serviceid,count(*) sum from user_log where serviceid!=-1 group by serviceid order by sum desc) a where rownum<11 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用你的语句建个视图,再对视图用select * from ... where rownum<11; select * from (select serviceid,count(*) sum ,rownum from user_log where serviceid!=-1 group by serviceid order by sum desc)rownum<11 上面的写错了,笔误select * from (select serviceid,count(*) sum ,rownum from user_log where serviceid!=-1 group by serviceid order by sum desc) where rownum<11 搞不定,还是建 个可以返回记录集的存储过程吧,在存储过程中建个temp表 select * from (select serviceid,count(*) sum from user_log where serviceid!=-1 group by serviceid order by sum desc) where rownum<11 直接select serviceid,count(*) sum from user_log where serviceid!=-1 and rownum<11 group by serviceid order by sum desc 就OK了! 排序以下!在条件下加上 desc 按什么排序然后在条件加上 desc select * from (select serviceid,count(*) sum ,rownum from user_log where serviceid!=-1 group by serviceid order by sum desc) where rownum<11 像这种排序后取前十的需要用两层的伪列.SELECT * FROM (SELECT ROWNUM NUM, LJJC FROM TABLE WHERE LJJC > 0 ORDER BY LJJC DESC) WHERE ROWNUM <= 10 linux下卸载oracle oracle一下情况记日志吗? oracle求和问题 论坛的各位兄弟姐妹们,你们知道如何把sybase数据库通过OCI移植到oracle数据库中吗? 根据主键从list集合中查出单独的实体信息 请教一个查询 oracle rman备份的问题。 各位大侠,请求一个oracle存储过程和临时表的问题!急急! 关于form_builder连接odbc的问题!!!!! sql里怎么得到一个date类型的值,它等于当月的第一天 这样的一个简单的触发器如何写啊(关于update),有正确结果马上结贴(在线) 创建存储过程问题(图形界面无法创建)
select * from (select serviceid,count(*) sum ,rownum from user_log where serviceid!=-1 group by serviceid order by sum desc) where rownum<11
select serviceid,count(*) sum from user_log where serviceid!=-1 and rownum<11 group by serviceid order by sum desc 就OK了!
SELECT *
FROM (SELECT ROWNUM NUM, LJJC
FROM TABLE
WHERE LJJC > 0
ORDER BY LJJC DESC)
WHERE ROWNUM <= 10