How to use the limit clause in sql?


-- Trying to retrieve a limited number of customers without using LIMIT
SELECT name FROM customers;

-- Correctly retrieving a limited number of customers using the LIMIT clause
SELECT name FROM customers LIMIT 5;
The LIMIT clause in SQL restricts the number of rows returned by a query. In this example, we limit the result to the first 5 customers.

Beginner's Guide to SQL