LIMIT in SQL

The LIMIT clause is used to restrict the number of rows returned by a query.

Syntax:

SELECT columnsFROM table_nameLIMIT number_of_rows;

• number_of_rows: The maximum number of rows to return.

Example:

Get the first 5 rows from the employees table:

SELECT * FROM employeesLIMIT 5;

Notes:

• LIMIT is supported by MySQL, PostgreSQL, SQLite, and some others.

• In SQL Server, use TOP instead:

SELECT TOP 5 * FROM employees;

• You can also combine LIMIT with OFFSET to skip rows:

SELECT * FROM employeesLIMIT 5 OFFSET 10;

This skips the first 10 rows, then returns the next 5.

If you want examples or info on pagination with LIMIT and OFFSET, just ask!