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 December 25, 2023.




Copyright © 2024   1keydata.com   All Rights Reserved     Privacy Policy     About   Contact