sql 分頁查詢

初始定義:

pageSize:每頁顯示大小

pageNum:第幾頁

Oracle分頁:

minus差分頁:

select * from table where rownum<=pageSize*pageNum minus select * from table where rownum<=(pageSize-1)*pageNum

例子:

 select * from table where rownum<=10 minus select * from table where rownum<=5

 兩個關聯表的符合條件記錄的交集,是于union作用相反.

例:

 select  *  from  table  where  rownum<=20  

 minus    

 select  *from  table  where  rownum<=10

SQLServer分頁：

select top pageSize*pageNum from table where id not in(select top (pageSize-1)*pageNum id from table );

例子

select top 5 * from table where id not in(select top 0 id from table);

MySQL分頁:

select * from table limit (pageSize-1)*pageNum,pageSize*pageNum;

select * from table limit 0,5;