您现在的位置是:蓝石榴 > 个人博客 > 数据库

个人博客

Oracle、Mysql、Sql sever2000数据库分页查询

2015-06-07数据库 3061
1.oracle分页查询 select t2.* from (select rownum r,t1.* from mytabl t1 where rownum<50) t2 where t2.r>40
1.oracle分页查询

select t2.* from (select rownum r,t1.* from mytabl t1 where rownum<50) t2 where t2.r>40

2.mysql分页查询

select * from mytabl limit 起始行, 每页多少行

3.sql sever2000分页查询

select * from(select top 页面容量 * from (select top 页面容量*当前页码 * from mytabl order by 字段A asc) order by 字段A desc)

很赞哦!(967)