The feature in last paragraph is already the case with plain ORDER BY. All
records in "group" order.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Stephan Buchert
Gesendet: Dienstag, 30. Jänner 2018 12:17
An:
SQLite is special WRT to non-aggregate columns in aggregate queries. Most other
engines will not allow columns that are neither group fields nor aggregated
fields. SQLite OTOH does, and it promises that these fields are "related" to
the group tuple.
Consider:
CREATE TABLE letters (type
What do you mean with groups ending and starting? The GROUP BY clause has the
effect of returning one record per group (i.e. distinct tuple of the group
expression), with the accumulated values belonging to that group. Each result
record is therefore in a separate group.
SQLite will (except
3 matches
Mail list logo