共通データベースのページングクエリ文

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;