Small. Fast. Reliable.
Choose any three.
Choose any three.
|
EXPLAIN QUERY PLAN
(eqp.html)
1.2. Temporary Sorting B-Trees
If a SELECT query contains an ORDER BY, GROUP BY or DISTINCT clause,
SQLite may need to use a temporary b-tree structure to sort the output
rows. Or, it might use an index. Using an index is
almost always ...
|
|
SELECT
(lang_select.html)
... The ORDER BY clause
If a SELECT statement that returns more than one row does not have an
ORDER BY clause, the order in which the rows are returned is undefined.
Or, if a SELECT statement does have an ORDER ...
|
|
Indexes On Expressions
(expridx.html)
1. How To Use Indexes On Expressions
... In order
to match WHERE clause constraints and ORDER BY terms to indexes, SQLite
requires that the expressions be the same, except for minor syntactic
differences such as white-space changes. So if you have:
CREATE TABLE t2(x,y ...
|
|
The WITH Clause
(lang_with.html)
... If an ORDER BY clause is present, it determines the order in which rows
are extracted from the queue in step 2a. If there is no ORDER BY clause,
then the order in which rows are extracted is undefined. (In ...
|
|
C API: Setting The Result Of An SQL Function
(c3ref/result_blob.html)
sqlite3_result_blob(), sqlite3_result_blob64(), sqlite3_result_double(), sqlite3_result_error(), sqlite3_result_error16(), sqlite3_result_error_toobig ...
... The byte-order specified by
the BOM at the beginning of the text overrides the byte-order
specified by the interface procedure. So, for example, if
sqlite3_result_text16le() is invoked with text that begins
with bytes 0xfe, 0xff (a big-endian ...
|
|
CREATE INDEX
(lang_createindex.html)
... Descending Indexes
Each column name or expression can be followed by one
of the "ASC" or "DESC" keywords to indicate sort order.
The sort order may or may not be ignored depending
on the database file format, and in particular ...
|
|
Datatypes In SQLite
(datatype3.html)
7.2. Collation Sequence Examples
... count(*) FROM t1 GROUP BY d ORDER BY 1;
--result 4
/* Grouping is performed using the BINARY collating sequence. 'abc' and
** 'ABC' and 'Abc' form different groups */
SELECT count(*) FROM t1 GROUP BY (d || '') ORDER BY 1;
--result 1 1 ...
|
|
The UINT Collating Sequence
(uintcseq.html)
1. Overview
The UINT collating sequences is a loadable extension for
SQLite that implements a new collating sequence that compares text
containing unsigned integers in numeric order.
The UINT collating sequence is not a standard part of SQLite.
It must be loaded ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
10.1. Partial ORDER BY via Index
If a query contains an ORDER BY clause with multiple terms, it might
be that SQLite can use indexes to cause rows to come out in the order
of some prefix of the terms in the ORDER BY but that ...
|
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... Information about the ORDER BY clause is stored in aOrderBy[].
Each term of aOrderBy records a column of the ORDER BY clause.
The colUsed field indicates which columns of the virtual table may be
required by the current scan. Virtual ...
|
Page generated by FTS5 in about 225.76 ms.