ROW_NUMBER 使用

WITH t_pageAS(

SELECT ROW_NUMBER() OVER ( ORDER BY table_name ) AS row_index,column_name FROM table_nameWHERE 1=1

)SELECT * FROM t_page WHERE row_index>=16 AND row_index<=28