I have a query that selects the top 20,000 records from a table based of various criteria. It has an order by on a set field.
What i want to do is get the value of the record in position 1000, 5000, 10000 and 20000.
The 20000 value i have been using the max function to retrive the value, but i cannot work out how to retrieve the other values without having to run 4 seperate queries
is there any way to do this