LIMIT SQL Keyword

TRF Docs
SQL Documentation
SQL Keywords
LIMIT

Overview

The LIMIT SQL keyword can be used in a query to tell the server to only retrieve the first x columns. The LIMIT keyword is usually followed by a number, like LIMIT 10. Here, the server will only return the first 10 columns.

Example
SQL
SELECT * FROM users LIMIT 50;

Here, the SELECT keyword tells the server to fetch all data from the 'users' table, but the LIMIT keyword indicates the server not to return more than the 50 first columns.

See also

SELECT
FROM