SQLite Syntax: 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