SQL SELECT TOP, LIMIT and ROWNUM Keywords


SELECT TOP, LIMIT and ROWNUM

The LIMIT, SELECT TOP or ROWNUM command is used to specify the number of records to return.

Note: SQL Server uses SELECT TOP. MySQL uses LIMIT, and Oracle uses ROWNUM.

The following SQL statement selects the first three records from the "Customers" table (SQL SERVER):

Example

SELECT TOP 3 * FROM Customers;
Try it Yourself »

The following SQL statement shows the equivalent example using the LIMIT clause (MySQL):

Example

SELECT * FROM Customers
LIMIT 3;
Try it Yourself »

The following SQL statement shows the equivalent example using ROWNUM (Oracle):

Example

SELECT * FROM Customers
WHERE ROWNUM <= 3;

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.