LIMIT.sql

SELECT DISTINCT id,name,state FROM customers LIMIT 5, /*LIMIT keyword is used to limit the search results*/
SELECT name,city,state FROM customers LIMIT 10,10 /*Start from 10th result and go down more 10*/