Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Window Functions
(windowfunctions.html)
1. Introduction to Window Functions
... SELECT x, y, row_number() OVER win1, rank() OVER win2
FROM t0
WINDOW win1 AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
win2 AS (PARTITION BY y ORDER BY x)
ORDER BY x;
The WINDOW clause, when one ...
|
|
DELETE
(lang_delete.html)
... The ORDER BY clause on a DELETE statement is used only to determine which
rows fall within the LIMIT. The order in which rows are deleted is arbitrary
and is not influenced by the ORDER BY clause.
This means that ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... ORDER BY isprim DESC;
SELECT 1 FROM private WHERE rid=68026;
SELECT value FROM tagxref WHERE tagid=8 AND tagtype>0 AND rid=68024;
SELECT pid FROM plink WHERE cid=68024 AND pid NOT IN phantom ORDER BY isprim ...
|
|
C API: Determine if a virtual table query is DISTINCT
(c3ref/vtab_distinct.html)
sqlite3_vtab_distinct()
... The integer returned by sqlite3_vtab_distinct()
gives the virtual table additional information about how the query
planner wants the output to be ordered. As long as the virtual table
can meet the ordering requirements of the query planner, it may set ...
|
|
RETURNING
(lang_returning.html)
... Even if SQLite is compiled with the SQLITE_ENABLE_UPDATE_DELETE_LIMIT
option such that ORDER BY clauses are allowed on DELETE and UPDATE
statements, those ORDER BY clauses do not constrain the output order
of RETURNING.
The values emitted by the RETURNING clause ...
|
|
Query Planning
(queryplanner.html)
2.1. Sorting By Rowid
Because sorting can be expensive, SQLite works hard to convert ORDER BY
clauses into no-ops. If SQLite determines that output will
naturally appear in the order specified, then no sorting is done.
So, for example, if you request the ...
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... For aggregate functions like max()
and count(), the input order does not matter. But for things like
string_agg() and json_group_object(), the ORDER BY clause will make a
difference in the result. If no ORDER BY clause is specified, the inputs ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
2. Details
... The completion table might return the same candidate more than once, and
it will return candidates in an arbitrary order. The DISTINCT keyword and
the ORDER BY in the sample query above are added to make the answers unique
and ...
|
|
UPDATE
(lang_update.html)
... The ORDER BY clause on an UPDATE statement is used only to determine which
rows fall within the LIMIT. The order in which rows are modified is arbitrary
and is not influenced by the ORDER BY clause.
|
|
C API: Function Flags
(c3ref/c_deterministic.html)
SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_SUBTYPE, SQLITE_INNOCUOUS, SQLITE_RESULT_SUBTYPE, SQLITE_SELFORDER1
... SQLITE_SELFORDER1
The SQLITE_SELFORDER1 flag indicates that the function is an aggregate
that internally orders the values provided to the first argument. The
ordered-set aggregate SQL notation with a single ORDER BY term can be
used to invoke this function ...
|
Page generated by FTS5 in about 249.27 ms.