Amy Hsieh6,023 Points
Q: The page can display 20 entries, I am asked to display the 3rd page of results.
This is my ANSWER:
SELECT * FROM phone_book ORDER BY last_name ASC, first_name ASC LIMIT 60 OFFSET 40
The system replied this query will result in 60 entries. I found the system message is misleading.
Steven Parker176,584 Points
The "LIMIT" value is how many to show, not the number of the last one. So if you "LIMIT 60", you'll get 60 results, no matter what the offset is (as long is it's not within 60 of the end).