Limit in SQL - sql - sql tutorial - learn sql
- The LIMIT clause restricts the number of results returned from a SQL statement. It is available in MySQL.
- For example, LIMIT10 would return the first 10 rows matching the SELECT criteria.
Syntax:
- The syntax for LIMIT is as follows:
[SQL Statement 1]
LIMIT [N];
- 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.
Example
- We use the following table for our example.
Table Store_Information
| Store_Name | Sales | Txn_Date |
|---|---|---|
| Los Angeles | 1500 | Jan-05-1999 |
| San Diego | 250 | Jan-07-1999 |
| Los Angeles | 300 | Jan-08-1999 |
| Boston | 700 | Jan-08-1999 |
- To retrieve the two highest sales amounts in Table Store_Information, we key in,
SELECT Store_Name, Sales, Txn_Date
FROM Store_Information
ORDER BY Sales DESC
LIMIT 2;
Result:
| Store_Name | Sales | Txn_Date |
|---|---|---|
| Los Angeles | 1500 | Jan-05-1999 |
| Boston | 700 | Jan-08-1999 |