Oracle 数据库的SQL语句分页
【IT168 服务器学院】Oracle 中：
select * from (select row_.*,rownum rownum_ from (真正的SQL语句) row_ where rownum <=?) where rownum_ > ?
SQL Server 中：
select top [pagesize] * from table where id not in (select top [pagesize] * (currentPage - 1) id from table [查询条件] order by id) and [查询条件] order by id
0
相关文章
关注我们
