SQL query to fetch first 10 rows from the table

• Use SELECT statement

• Add LIMIT clause with 10 as argument

• Optionally, use ORDER BY clause for specific order