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.
The basic syntax of the SELECT statement with LIMIT is given below –
SELECT * FROM table_name LIMIT numeric_value;
SELECT * FROM employees LIMIT 3;
Here it will retrieve the top 3 records from the employees' table.