Mysql系列(十三)分頁查詢語句

mysql系列(十三)分頁查詢語句

mysql

?select?tablename.*??from??tablename?limit?firstIndex,pageSize;  ??????????firstIndex?-------->開始索引  ??????????pageSize--------->頁大小

Oracle

select?*?from?(  ???????????????????????????select?a.*,ROWNUM?rn?from?tablename?a?where?ROWNUMfirstIndex;

?

? ? ?2. ? ? ? ?

?select?*?from(select?*?from(select?p.*,ROWNUM?rn?from?tablename?)p??where?p.rownumber>firstIndex)??where?rownum>pageSize;

以上就是mysql系列(十三)分頁查詢語句的內容,更多相關內容請關注PHP中文網(www.php.cn)!

? 版權聲明
THE END
喜歡就支持一下吧
點贊14 分享