MySQL uses LIMIT

The SELECT TOP clause is used to specify the number of records to return.

The SELECT TOP clause is useful on large tables with thousands of records. Returning a large number of records can impact performance.

Select only the fitst x records

This statement returns first 3 records in the Customers table

SELECT * FROM Customers
LIMIT 3;

MySQL syntax

MySQL uses LIMIT to achieve the SELECT TOP

SELECT column_name(s)
FROM table_name
WHERE condition
**LIMIT number;**