Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... group_concat(X)group_concat(X,Y)string_agg(X,Y)
The group_concat() function returns
a string which is the concatenation of
all non-NULL values of X. If parameter Y is present then
it is used as the separator
between instances of ...
|
|
Window Functions
(windowfunctions.html)
2.1. The PARTITION BY Clause
... For example:
-- The following SELECT statement returns:
--
-- c | a | b | group_concat
---------------------------------
-- one | 1 | A | A.D.G
-- one | 4 | D | D.G
-- one | 7 | G | G
-- three | 3 | C | C.F
-- three | 6 | F | F
-- two | 2 | B | B.E ...
|
|
The WITH Clause
(lang_with.html)
... cx, cy FROM m GROUP BY cx, cy
),
a(t) AS (
SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '')
FROM m2 GROUP BY cy
)
SELECT group_concat(rtrim(t),x'0a') FROM a;
In this query, the "xaxis" and "yaxis ...
|
|
ANALYZE
(lang_analyze.html)
... Then capture
the result of this one-time ANALYZE using a script like the
following:
.mode list
SELECT
'ANALYZE sqlite_schema;' ||
'DELETE FROM sqlite_stat1;' ||
'INSERT INTO sqlite_stat1(tbl,idx,stat)VALUES' ||
(SELECT group_concat(format('(%Q,%Q,%Q)',tbl,idx,stat),',')
FROM ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... coalesce(euser, user) AS user,
blob.rid IN leaf AS leaf,
bgcolor AS bgColor,
event.type AS eventType,
(SELECT group_concat(substr(tagname,5), ', ') FROM tag, tagxref
WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid
AND tagxref.rid=blob.rid ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
5.1. Case Study: Upgrading Fossil to the NGQP
... coalesce(euser, user) AS user,
blob.rid IN leaf AS leaf,
bgcolor AS bgColor,
event.type AS eventType,
(SELECT group_concat(substr(tagname,5), ', ')
FROM tag, tagxref
WHERE tagname GLOB 'sym-*'
AND tag.tagid=tagxref.tagid
AND tagxref.rid=blob.rid ...
|
Page generated by FTS5 in about 14.85 ms.