It seems that the method of as400 (iseries) Paging statements is particularly effective for massive volumes.

The
1. The host v5r4, that is, the I5 machine, has a function row_number ()-this is not verified because its host environment is v5r3.
Select * from (select row_number () over (order by ID) as RN, * From Table1) as Te

2. The host is v5r3 or the following statements can be used:
The following statements show 16-20 results.

With X as (select col1, col2,... coln from mytable
Where...
Order by key1, key2,... keyn
Fetch first 20 rows only), // use commas to separate the first 20 rows.
Y as (select * from X
Order by key1 DESC, key2 DESC,... keyn DESC
Fetch first 5 rows only) // obtain the first five
Select * from Y
Order by key1, key2... keyn // obtain all data from the second filter. The principle is to use a temporary table.