How to select first 10 elements from database using SQL?

Question

There is a query like SELECT * FROM clients ORDER BY id. I want to select only first 10 elements. How can I do this?

P.S. I'm using MySQL.

Answer 1

SELECT * FROM clients ORDER BY id LIMIT 10;

Answer 2

Note that OFFSET is very helpful to paginate:

LIMIT 10 OFFSET 11

for the second page of 10.