常用数据库的分页查询语句
不同数据库的分页方式:MySQL:select * from tb_name limit skipRow, pageSize;// 不要求任何字段有序select * from tb_name where id > skipRowand id < (skipRow + pageSize);// 必须ID有序select * from tb_name where ...
·
不同数据库的分页方式:
MySQL:
select * from tb_name limit skipRow, pageSize; // 不要求任何字段有序
select * from tb_name where id > skipRow and id < (skipRow + pageSize); // 必须ID有序
select * from tb_name where id > skipRow limit pageSize;
Oracle:(ROWNUM隐含字段值或row_number(函数))
select rownum, xxx_cols from tb_xxx where rownum between 10 and 15
firstIndex: 起始索引
pageSize: 每页显示的数量
select * from (select ROWNUM as rn, a.* from XXX a where ROWNUM <= (firsrIndex + pageSize) ) where rn > firstIndex。
SQL Server:(row_number()函数)
firstIndex:起始索引
pageSize:每页显示的数量
orderColumn:排序的字段名。
select top pageSize 0.* from (select row_number() over(order by orderColumn) as rownumber.*) from XXX as o where rownumber > firstIndex;
更多推荐
所有评论(0)