Check out example codes for "limit offset order by mysql". It will help you in understanding the concepts better.

Code Example 1

SELECT 
    column_list
FROM
    table1
ORDER BY column_list
LIMIT row_count OFFSET offset;

Code Example 2

$sql = "SELECT * FROM Orders LIMIT 10 OFFSET 15";

Learn ReactJs, React Native from akashmittal.com