How to find the n-th record ?

[Shuja Ali]

I said I want the n-th record (order by field), n is large, but not the total !!!
not the last record order by field or max(field) record !!

For example, if a database contains 400000000 records
and the query produces below records from R1 to Rn
( order by field ) , there n large than 1000000 and less than 4000000000

R1, R2, R3, ........... , R1000000, R1000001 .......... , Rn

I want to get the record - R1000000 , not Rn !!

Have you tried the solutions that were suggested?