The Base85() SQL Function
(base85.html)
2. Encoding
... Groups of 1-3 bytes are represented with 2-4 digits,
still big-endian but 8-24 bit values. (Using big-endian yields
the simplest transition to byte groups smaller than 4 bytes.
These byte groups can also be considered ...
|
Window Functions
(windowfunctions.html)
2.2.1. Frame Type
... The GROUPS frame type means that the starting and ending boundaries
are determined by counting "groups" relative to the current group.
A "group" is a set of rows that all have equivalent values for all
all terms of the window ...
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... count(X)count(*)
The count(X) function returns
a count of the number of times
that X is not NULL in a group. The count(*) function
(with no arguments) returns the total number of rows in the group.
group_concat(X ...
|
SELECT
(lang_select.html)
... Each row
is then assigned to a "group" based on the results; rows for which
the results of evaluating the GROUP BY expressions are the same get
assigned to the same group. For the purposes of grouping rows, NULL
values ...
|
C API: Introduction
(c3ref/intro.html)
... The SQLite interface elements can be grouped into three categories:
List Of Objects.
This is a list of all abstract objects and datatypes used by the
SQLite library. There are couple dozen objects in total, but
the two most important ...
|
SQLite Keywords
(lang_keywords.html)
... EACH
ELSE
END
ESCAPE
EXCEPT
EXCLUDE
EXCLUSIVE
EXISTS
EXPLAIN
FAIL
FILTER
FIRST
FOLLOWING
FOR
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP
GROUPS
HAVING
IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LAST
LEFT ...
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
6. Aggregate Queries Can Contain Non-Aggregate Result Columns
That Are Not In The GROUP BY Clause
In most SQL implementations, output columns of an aggregate query
may only reference aggregate functions or columns named in the
GROUP BY clause. It does not make good sense to reference an ordinary
column in an aggregate query because each ...
|
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 ...
|
Full-Featured SQL
(fullsql.html)
... ACID transactions using BEGIN, COMMIT, and ROLLBACK
Nested transactions using SAVEPOINT, RELEASE, and
ROLLBACK TO
Subqueries, including correlated subqueries
Up to 64-way joins
LEFT, RIGHT, and FULL OUTER JOINs
DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
UNION ...
|
C API: Run-Time Limit Categories
(c3ref/c_limit_attached.html)
SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ...
... SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the
result set of a SELECT or the maximum number of columns in an index
or in an ORDER BY or GROUP BY clause.
SQLITE_LIMIT_EXPR_DEPTH
The maximum depth ...
|
Page generated by FTS5 in about 70.72 ms.