排序?? select * from (select rownum rm,a,b,c from table order by a desc) where rm>10 and rm<20 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 排序后取M到N条记录:select * from(select rownum rn,a.* from table_name a order by colname [desc])where rn>=M and rn<=N 这样好像是先取得N-M个数据再按a排序,我是想先按a排好序再取N-M个数据。 select * from (select rownum rm,a,b,c from table order by a desc) where rm>9 and rm<20 select * from (select rm,t1.* from (select a,b,c from table order by a desc) t1)where rm>9 and rm<20 select * from (select rownum "RM",a,b,c from table order by a desc) where rm>9 and rm<20我试了没有问题 上面的排序语句都有问题,排序后rownum就乱了select * from (select rownum id,t.* from (select a,b,c from table order by a desc) t where id<21) where id>10; 关于实例恢复,redo和undo 外部表的乱码 本机定时备份问题? mssql中的chrtran等同于oracle中的相应的函数 急!!数据库速度变慢的问题!! 恢复数据库空间表'USERS01.DBF' 请问如何往数据库里存储 图片 文件?求例子语句!!! 存储过程里面,不可以引用另一用户的表的吗? ORACLE怎么定时数据备份(在线等) 遇到一个关于序列的奇葩问题 请教文本数据怎么导会ORACLE 大家来看看这个SQL语句.
select * from(select rownum rn,a.* from table_name a order by colname [desc])
where rn>=M and rn<=N
where rm>9 and rm<20
我试了没有问题
select rownum id,t.* from (select a,b,c from table order by a desc) t where id<21
) where id>10;