Listing 2: Generalized Paging Query That Includes Sorting Clauses
SELECT TOP page_size * 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