Small. Fast. Reliable.
Choose any three.

factored-select-stmt

WITH RECURSIVE common-table-expression , select-core ORDER BY LIMIT expr compound-operator ordering-term , OFFSET expr , expr



References:   common-table-expression   compound-operator   expr   ordering-term   select-core

See also:   lang_select.html