How to select first 10 rows in SQL?

Question

Can anyone explain how to select first 10 rows in SQL?

Answer 1

In SQL Server, we can use the TOP keyword to return the first 10 rows of the table. Here is an example to return the first 10 rows:

SELECT TOP 10 *

FROM table_name;

In MySQL, we can use the LIMIT keyword to return the first 10 rows of the table:

SELECT * FROM Table_Name
LIMIT 10;

I recommend this SQL training course by Intellipaat to become an expert in SQL.

Answer 2

Select top 10 * from tablename

Here use select to retrieve data and using top 10 to get the first 10 rows from the table.