When applications need to page through query results, a very common (but often inefficient) pattern shows up: SELECT some_columns FROM some_table ORDER […]