syntax to select top 10 rows in mysql code example Example: top 10 rows in mysql select * from table_name ORDER BY id LIMIT 10;