order by and limit offset in mysql code example
Example: limit offset order by mysql
SELECT
column_list
FROM
table1
ORDER BY column_list
LIMIT row_count OFFSET offset;
SELECT
column_list
FROM
table1
ORDER BY column_list
LIMIT row_count OFFSET offset;