ORCLE使用ROW_NUMBER()实现分页

SELECT * FROM (     SELECT T_ORACLE.*, ROW_NUMBER() OVER (ORDER BY image_failed_no,document_id) AS ROW_  FROM (           select * from image_failed_detail        --sql语句    ) T_ORACLE    ORDER BY  image_failed_no,document_id) TEMP_ WHERE ROW_ BETWEEN 10 AND 2 0