The SQL LIMIT clause restricts how many rows are returned from a query. The syntax for the LIMIT clause is: SELECT * FROM table LIMIT X;. X represents how many records you want to retrieve. For example, you can use the LIMIT clause to retrieve the top five players on a leaderboard

1. SQL Server / MS Access Syntax: SELECT TOP number|percent column_name(s)
2. MySQL Syntax: SELECT column_name(s)
3. Oracle 12 Syntax:
4. Older Oracle Syntax:
5. Older Oracle Syntax (with ORDER BY):

The SQL LIMIT clause limits the number of rows returned by a query. The LIMIT clause is written as: SELECT * FROM table LIMIT X;. X is the number of records you want to retrieve. You can, for example, use the LIMIT clause to get the top five players on a leaderboard.