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