Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Implementation Limits For SQLite
(limits.html)
... Maximum Number Of Terms In A Compound SELECT Statement
A compound SELECT statement is two or more SELECT statements connected
by operators UNION, UNION ALL, EXCEPT, or INTERSECT. We call each
individual SELECT statement within a compound SELECT a "term ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
9. Keywords Can Often Be Used As Identifiers
... CREATE TABLE union(true INT, with BOOLEAN);
The same SQL statement will fail on every other SQL implementation that
we know of due to the use of keywords "union", "true", and "with" as
identifiers.
The ability to use keywords as ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
4.2. Evaluating OR constraints separately and taking the UNION of the result
... rowid IN (SELECT rowid FROM table WHERE expr1
UNION SELECT rowid FROM table WHERE expr2
UNION SELECT rowid FROM table WHERE expr3)
The rewritten expression above is conceptual; WHERE clauses containing
OR are not really rewritten this way.
The actual ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.3. The zipfile() Aggregate Function
... WITH contents(name, data) AS (
VALUES('a.txt', 'abc') UNION ALL
VALUES('b.txt', '123')
)
SELECT zipfile(name, data) FROM contents;
This page last modified on 2023-06-07 13:17:51 UTC
|
|
SQL Language Expressions
(lang_expr.html)
... All types of SELECT statement, including
aggregate and compound SELECT queries (queries with keywords like
UNION or EXCEPT) are allowed as scalar subqueries.
The value of a subquery expression is the first row of the result
from the enclosed SELECT ...
|
|
Profiling SQL Queries
(profile.html)
3. Complex Cases - Rows, Loops and Cycles
... sqlite3> WITH cnt(i) AS (
SELECT 1 UNION SELECT i+1 FROM cnt WHERE i<100
)
SELECT
*, (SELECT d FROM t2 WHERE c=ft.rowid)
FROM
(SELECT count(*), a FROM t1 GROUP BY a) AS v1 CROSS JOIN ...
|
|
Datatypes In SQLite
(datatype3.html)
6. Sorting, Grouping and Compound SELECTs
... The compound SELECT operators UNION,
INTERSECT and EXCEPT perform implicit comparisons between values.
No affinity is applied to comparison operands for the implicit
comparisons associated with UNION, INTERSECT, or EXCEPT - the values
are compared as is.
|
|
SQLite Frequently Asked Questions
(faq.html)
... SELECT name FROM
(SELECT * FROM sqlite_schema UNION ALL
SELECT * FROM sqlite_temp_schema)
WHERE type='table'
ORDER BY name
(8) Are there any known size limits to SQLite databases?
See limits.html for a full discussion of
the limits of SQLite.
(9 ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
3.1.
Set Operations Using The Enhanced Query Syntax
... SELECT docid FROM docs WHERE docs MATCH 'sqlite AND database'
UNION
SELECT docid FROM docs WHERE docs MATCH 'library';
-- Query for the set of documents that contains the term "linux", and at least
-- one of the phrases "sqlite database" and ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SELECT statements that use the
UNION, UNION ALL, INTERSECT or EXCEPT compound SELECT operators will
cause a parse error.
An INSERT statement with multiple values in the VALUES clause is
implemented internally as a compound SELECT. Hence, this option also ...
|
Page generated by FTS5 in about 40.45 ms.