Kimbal Technologies interview question

Question related to Pagination in SQL