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
