In the Pagination you are generally interested in taking some complex query, sorting it and then retrieving just the first N rows. ROWNUM ha...