Mysql数据库 :--表名:可以是单表的查询语句,也可以是多表的联合查询语句; firstIndex:其实的索引;pageSize:每页显示的记录数。 select o.* from (表名) o limit firstIndex,pageSize; 例子: select l.* from lduser l limit 0,20; ---- 查询lduser表,从第1条开始,查询20条
|
Oracle数据库: 1. rownum 查询通式 select * from(select l.*,rownum rn from lduser l where ROWNUM<=(firstIndex+pageSize)) where rn>firstIndex (ROWNUM<=(firstIndex+pageSize),rn>firstIndex;作为参数传入) 或是 select l.* from (select rownum rn,l.* from lduser l ) where l.rn > 10 and l.rn <= 20 order by l.rn; (l.rn > 10 and l.rn <= 20,作为参数传入) 2. row_number()解析函数分页查询通式: -- firstIndex:起始索引;pageSize:每页显示的数量;orderColumn:排序的字段名 -- sql:可以是简单的单表查询语句,也可以是复杂的多表联合查询语句 select * from (select * from (select l.*, row_number() over(order by userid) as rownums from lduser l) p where p.rownums > firstIndex) where rownum <= pageSize |
Sqlserver数据库:-- 查询lduser表,从第11条数据开始,查询10条数据 select top 10 l.* from (select row_number() over(order by userid) as rownums, * from lduser ) l where rownums >10 |