Limiting results with LIMIT

•    The LIMIT clause in SQL allows users to control the amount of data retrieved and displayed in the result set.

 

          SELECT column1, column2, . . .

          FROM table_name

          WHERE condition

          ORDER BY column

          LIMIT [offset.] row_count;

 

EXAMPLE:

 

          SELECT * FROM users         

          WHERE age > 30

          ORDER BY age

          LIMIT 5;