A SELECT query is used to retrieve records from one or more tables. It does support filters set on each table, joining tables and sort options. Pagination can be used by setting the start offset and the query limit.
The maximum number of records to be selected.
The offset for selecting the records. ??
The field(s) the records will be sorted by.
The tables the select is executed on, each with it's fields.