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