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 ...
|
Window Functions
(windowfunctions.html)
2.2.1. Frame Type
... The GROUPS frame type means that the starting and ending boundaries
are determine 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 ...
|
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 ...
|
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 ...
|
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 ...
|
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 ...
|
Datatypes In SQLite
(datatype3.html)
6. Sorting, Grouping and Compound SELECTs
... When grouping values with the GROUP BY clause values with
different storage classes are considered distinct, except for INTEGER
and REAL values which are considered equal if they are numerically
equal. No affinities are applied to any values as the ...
|
Page generated by FTS5 in about 61.28 ms.