top、rownum、limit 用法
eg:取数据前10条
oracle: select *from table where rownum<=10
slqserver : select top 10 * from table
mysql: select * from table limit 10
eg:取数据第10 条到15条 用到row_number()
oracle: 按照tname排序
select tname,tabtype from (
select tname,tabtype,row_number() over ( order by tname ) rn from tab
) where rn between 100 and 150;
slqserver :按照时间排序排序
select *
from (select row_number() over(order by getdate()) 'rn',*
from [表名]) t
where rn between [起始行号] and [结束行号]
mysql: SELECT* FROM dede_archives LIMIT 10,5
分页 :
oracle: 分页并排序
select * from (select a.*,rownum row_num from (select * from mytable t order by t.id desc) a ) b where b.row_num between 1 and 10原文链接：http://www.jxszl.com/biancheng/shujuku/445426.html
