CODE EXAMPLE FOR SQL

mysql limit order by

SELECT select_list
FROM table_name
ORDER BY order_expression
LIMIT offset, row_count;