Listing 3: Generalized Query That First Restricts a Search to the Primary Key
SELECT * FROM table WHERE primary key IN
(SELECT TOP page_size primary_key FROM table WHERE primary_key NOT IN
(SELECT TOP page_size * (page_number - 1) primary_key FROM table
WHERE filter_conditions
ORDER BY sort_field)
AND filter_criteria
   ORDER BY sort_field)
ORDER BY sort_field