ROWNUM
- 得到某次查询的第一行
SELECT t.* FROM TABLE_NAME t WHERE ROWNUM = 1;
- 得到第二行
SELECT * FROM (
SELECT
ROWNUM ROW_NO,
t.*
FROM
TABLE_NAME t
) temp
WHERE temp.ROW_NO = 2
- 查询前10条
SELECT
ROWNUM ROW_NO,
t.*
FROM
TABLE_NAME t
WHERE ROWNUM != 11
- 分页(假如取第11-20条数据)
思路:子查询先取前20条,再取大于10的
SELECT * FROM (
SELECT
ROWNUM ROW_NO,
t.*
FROM
TABLE_NAME t
WHERE ROWNUM <= 20
) temp
WHERE temp.ROW_NO > 10