The following SQL statement selects the first three records from the "Customers" table (for SQL Server/MS Access):
Example
SELECT TOP 3 * FROM Customers;
The following SQL statement shows the equivalent example for MySQL:
Example
SELECT * FROM Customers
LIMIT 3;
LIMIT 3;
The following SQL statement shows the equivalent example for Oracle:
Example
SELECT * FROM Customers
FETCH FIRST 3 ROWS ONLY;
FETCH FIRST 3 ROWS ONLY;
Practice Excercise Practice now