SQL LIMIT

SQL > Advanced SQL > Limit

The LIMIT clause restricts the number of results returned from a SQL statement. It is available in MySQL, Hive, and Google BigQuery.

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
San Francisco	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

The SQL Server equivalent to LIMIT is TOP.

Next: SQL TOP

This page was last updated on October 12, 2024.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.