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