limit in sql
#SELECT * FROM Customers LIMIT number_of_rows;
SELECT * FROM Customers LIMIT 3;
#return first 3 rows
#SELECT * FROM Customers LIMIT start,number_of_rows;
SELECT * FROM Customers LIMIT 0,3;
#return 3 rows starting from 0
SELECT * FROM Customers LIMIT 2,3;
#return 3 rows starting from 2
#SELECT * FROM Customers LIMIT number_of_rows OFFSET y;
SELECT * FROM Customers LIMIT 2 offset 3;
#skip the first 3 rows and then return the next 2 rows