3回答

• 

  慕粉2349237414

  2016-11-07 16:37:21

  这个分页有点难，听不懂的感觉
  

  1 0

  Vardis

  --page 第几页 size 一页几条数据 SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM all_worker_ t WHERE ROWNUM <= page*size) table_alias WHERE table_alias.rowno > (page-1)*size;

  2021-08-05 11:52:11

  共 1 条回复 >

• 

  Jery227

  2015-11-20 04:24:24

    SELECT * FROM (SELECT ROWNUM rNUM,e.* FROM (SELECT * FROM emp ORDER BY sal DESC) e)
     WHERE rNUM>=5 AND rNUM<=8

  0 0
• 

  wearksidy_yxp

  2015-08-24 09:59:29

  测完之后懂了，thx~
  

  0 0