SQL Tutorial: select top tutorial

SQL Tutorial: select top tutorial

Now let's look at the select top syntax.

For example, mssql: select top 10 from table_name

In mysql: select * from table_name limit 0, 10

SELECT TOP number|percent column_name(s)FROM table_name

Let's take a look at the example tutorial.

_ Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3	Pettersen	Kari	Storgt 20	Stavanger
4	Nilsen	Tom	Vingvn 23	Stavanger

Mssql or access select top 2 * FROM Persons

mysql select * from persons limit 0,2

Their output results are the same in the following table.

Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes