SQL -Structured Query Language - Sql Select - Select - Limit Tutorial

To retrieve a certain topmost record out of the total record from the existing created table. Then we can use a ' SELECT ' statement with LIMIT.

Syntax-

The basic syntax of the SELECT statement with LIMIT is given below –

SELECT * FROM table_name LIMIT numeric_value;

For example-

SELECT * FROM employees LIMIT 3;

Run Query

Here it will retrieve the top 3 records from the employees' table.