SELECT QUERY TO LIMIT

SELECT QUERY TO LIMIT RECORDS WITH PAGINATION
SYNTAX:
---------
SIMPLE

FOR PAGINATION
SELECT * FROM TABLE_NAME LIMIT PAGENO*LIMITVALUE, LIMITVALUE;

EXAMPLE
---------

This Query will show first 10 records from table

This Query will show 10 records after 10 records of table

This Query will show 10 records after 70 records of table