SELECT * FROM |
2 | ( |
3 | SELECT B.*, ROWNUMBER() OVER() AS RN FROM |
4 | ( |
5 | SELECT * FROM <TABLE_NAME> |
6 | ) AS B |
7 | ) AS A WHERE A.RN BETWEEN <START_NUMBER> AND <END_NUMBER>; |
SELECT * FROM |
2 | ( |
3 | SELECT B.*, ROWNUMBER() OVER() AS RN FROM |
4 | ( |
5 | SELECT * FROM <TABLE_NAME> |
6 | ) AS B |
7 | ) AS A WHERE A.RN BETWEEN <START_NUMBER> AND <END_NUMBER>; |