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 SQLite is in the Public Domain. https://sqlite.org/syntax/simple-select-stmt.html