WITH t_page
AS(
SELECT ROW_NUMBER() OVER ( ORDER BY table_name ) AS row_index,
column_name FROM table_name
WHERE 1=1
)
SELECT * FROM t_page WHERE row_index>=16 AND row_index<=28
WITH t_page
AS(
SELECT ROW_NUMBER() OVER ( ORDER BY table_name ) AS row_index,
column_name FROM table_name
WHERE 1=1
)
SELECT * FROM t_page WHERE row_index>=16 AND row_index<=28