row_number 可以使用between .... and .. ,而rownum不可以使用,
Row_number: Select * from (
SELECT 字段名, ROW_NUMBER() OVER (ORDER BY 排序名 desc) AS 新列名 FROM 表名 ) where新列名 between 起始行 and 终止行 (摘自:http://docs.oracl
row_number 可以使用between .... and .. ,而rownum不可以使用,
Row_number: Select * from (
SELECT 字段名, ROW_NUMBER() OVER (ORDER BY 排序名 desc) AS 新列名 FROM 表名 ) where新列名 between 起始行 and 终止行 (摘自:http://docs.oracl