主流数据库对分页查询都有不同程度的支持,下面分别是SQLServer、Oracle、MySQL的分页查询语句(从cpcode表中查询出90-100的10条记录),以备查询。
SQLServer:
1.Oracle数据库:
selelct * from (select rownum rn,code,name from cpcode where rn>90)s where s.rn<100;
oracle的实现分页的第二种形式:
select * from (select rownum rn,rncode,name from cpcode)s where s.rn between 90 and 100;
2.MySql数据库:
MySql数据库是实现分页显示最简单的:用limit关键字就行了
select * from cpcode where limit 90,10;
3.SqlServer利用top关键字
select * from (select top 10 * from (select top 100 * from cpcode order by code) a order by code desc) as b order by code