To display certain list of records from the database, put the list of records to display using the LIMIT. It specifies the number of records which wanted to select form the table.
Example
$sql = "SELECT * FROM Orders LIMIT 100";
Here 100 records are selected from the table to display.
Suppose there are 30 to 60 records. To start displaying records form 30,use OFFSET Statement. Below example explains about it.
$sql = "SELECT * FROM Orders LIMIT 30 OFFSET 29";
Summary
Key Points
To display only selected records the LIMIT statement is used.
To display the records in a certain range, OFFSET is used.