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


   作者蓝石榴    由lan16转载自蓝石榴    更新于2015-06-07 11:09    已被浏览1314次

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)

豫ICP备13022176号-2   鄂公网安备 42010602000416号   Copyright © 2013 - 2020 蓝石榴. All Rights Reserved  联系我 联系我 蓝石榴技术社区