per mySql la condizione è LIMIT

https://www.w3schools.com/sql/sql_top.asp

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

Example
SELECT * FROM Customers
LIMIT 3;