Coding task · SQL and MySQL course · Module 2: Querying data (SELECT)

Paginating readers

Skip the first 10 rows and show the next 5 - this is classic pagination.

Task

Write a query that retrieves all columns from the czytelnicy table, sorts the rows by id, skips the first 10 and shows the next 5 (use ORDER BY, LIMIT and OFFSET).