limit

SQL LIMIT Clause

SQL LIMIT Clause

The LIMIT clause is used to specify the number of records to return in the result set.

Basic LIMIT Example

SELECT first_name, last_name FROM Users
LIMIT 5;
    

This query retrieves the first 5 rows from the "Users" table.