SQL Beginner Tutorial: Select top Use tutorial

SQL Beginner Tutorial: Select top Use tutorial

OK, let's take a look at the syntax in select Top.

such as Mssql:select top 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 an example tutorial.

Address City

_id	LastName	FirstName
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

They output the same results as the following table.

Address City

Id	LastName	FirstName
1	Hansen	Ola	TIMOTEIVN 10	Sandnes
2	Svendson	Tove	BORGVN 23	Sandnes