Junior SQL

What is the LIMIT clause in SQL?

The LIMIT clause is used to specify the number of records returned by a SELECT query. It is

commonly used to restrict the number of rows, especially for pagination.

Example:

SELECT * FROM Employees LIMIT 5;

This will return only the first 5 rows from the Employees table.

More from SQL Server Tutorial

All questions for this course