1、查询前十条记录:
SELECT T.* FROM TEST_STUDY t WHERE ROWNUM <=10
2、查询第二条到第六条的记录:
SELECT *
FROM (SELECT T.*, ROWNUM R FROM TEST_STUDY t WHERE ROWNUM < =6)
WHERE R >=2
3、查询排名第二的学生成绩
SELECT ID, NAME, SCORE, 排名
FROM (SELECT ID, NAME, SCORE, RANK() OVER(ORDER BY SCORE DESC) "排名"
FROM TEST)
WHERE 排名 = 2;