From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/syntax/compound-select-stmt.html | 263 +++++++++++++++++++++++++++++++++++ 1 file changed, 263 insertions(+) create mode 100644 www/syntax/compound-select-stmt.html (limited to 'www/syntax/compound-select-stmt.html') diff --git a/www/syntax/compound-select-stmt.html b/www/syntax/compound-select-stmt.html new file mode 100644 index 0000000..943048b --- /dev/null +++ b/www/syntax/compound-select-stmt.html @@ -0,0 +1,263 @@ + + + + + +SQLite Syntax: compound-select-stmt + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

compound-select-stmt

+
+
+ + + + + + +WITH + +RECURSIVE + + + + + +common-table-expression + + + + + + +, + + + + +select-core + +ORDER + + + +BY + +LIMIT + + + +expr + + + + + + + + +UNION + +UNION + + + +ALL + + + + + +select-core + +INTERSECT + +EXCEPT + + + + + + + + + + + + + + + + + + + + + + + +ordering-term + +, + + + + + + + + + + + + + +OFFSET + + + +expr + + + +, + + + +expr + + + + + + + + + + + + + + + + + + + +

+

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

+See also:   lang_select.html +
+ + + -- cgit v1.2.3