Parameters or Arguments
The columns or calculations that you wish to retrieve.
The tables that you wish to retrieve records from. There must be at least one table listed in the FROM clause.
The conditions that must be met for the records to be selected.
ORDER BY clause
It is used in the SELECT LIMIT statement so that you can order the results and target those records that you wish to return.
It specifies a limited number of rows in the result set to be returned based on number_rows. For example, LIMIT 10 would return the first 10 rows matching the SELECT criteria. This is where sort order matters so be sure to use an ORDER BY clause appropriately.
Optional. The first row returned by LIMIT will be determined by offset_value.