Sergey Sergey - 1 year ago 111
MySQL Question

How to select first 10 elements from database using SQL?

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 Source
SELECT * FROM clients ORDER BY id LIMIT 10;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download