Small. Fast. Reliable.
Choose any three.

simple-select-stmt

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



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

See also:   lang_select.html