分页SQL

1. mysql分页：limit 关键字

   SELECT * FROM 表名 LIMIT 1,5; 

2. Oracle分页：rownum 关键字

   查询emp表第二页数据，每页显示五条    SELECT * FROM (        SELECT ROWNUM RN,T.*             FROM (                SELECT * FROM EMP E GROUP BY E.SAL DESC                ) T WHERE ROWNUM < 11        ) WHERE RN > 5;