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.