数据库分页查询

Oracle

ROWNUM 分页查询格式

SELECT * FROM 
(
SELECT A.*, rownum rownum_ 
FROM (SELECT * FROM TABLE_NAME) A 
WHERE rownum <= #end#
)
WHERE rownum_ >= #start#


mssql
row_number()分页查询

select * from 
(
select *,row_number() over(order by 字段) as rn from 表名
) tt 
where tt.rn between n and m

top分页查询

select top @pageSize * from table where Id not in
(select top @pageSize*@currentPage Id from table order by id) order by id

select top @pageSize * from table where id>(select max(id) from
(select top (@pageSize*@currentPage) id from table order by id) a)
order by id