共通データベースのページングクエリ文
749 ワード
:
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;