数据库：mySql的limit

mysql: select * from TM_CATEGORY order by ID desc limit 5  表示检索前五行

mysql: select * from TM_CATEGORY order by ID desc limit 5，10  表示检索6到15行

如果用oracle实现，如果字段只有ID,NAME两个

oracle: select ID, NAME from (select ID, NAME ,ROWNUM as NUM from TM_CATEGORY order by ID) where NUM between 6 and 15;

转载于:https://my.oschina.net/u/3953338/blog/2249107