w1coding.comAll tutorials

SQL Limit

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL LIMIT Clause

The LIMIT clause is used to specify the number of records to return in the result set.

Basic LIMIT Example

SELECT first_name, last_name FROM Users
LIMIT 5;
    

This query retrieves the first 5 rows from the "Users" table.