SQL > Advanced SQL >
The LIMIT clause restricts the number of results returned from a SQL statement. It is available in MySQL.
The syntax for LIMIT is as follows:
[SQL Statement 1]
where [N] is the number of records to be returned. Please note that the ORDER BY clause is usually included in the SQL statement. Without the ORDER BY clause, the results we get would be dependent on what the database default is.
We use the following table for our example.
To retrieve the two highest sales amounts in Table Store_Information, we key in,
SELECT Store_Name, Sales, Txn_Date
ORDER BY Sales DESC
The SQL Server equivalent to LIMIT is TOP.