From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/syntax/factored-select-stmt.html | 230 +++++++++++++++++++++++++++++++++++ 1 file changed, 230 insertions(+) create mode 100644 www/syntax/factored-select-stmt.html (limited to 'www/syntax/factored-select-stmt.html') diff --git a/www/syntax/factored-select-stmt.html b/www/syntax/factored-select-stmt.html new file mode 100644 index 0000000..4b90a2b --- /dev/null +++ b/www/syntax/factored-select-stmt.html @@ -0,0 +1,230 @@ + + + + + +SQLite Syntax: factored-select-stmt + + + +
+ + + +
+
+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 +
+ + + -- cgit v1.2.3