4 ms·
See also these unofficial interactive release notes: https://antonz.org/sqlite-3-44/ https://antonz.org/sqlite-3-44/ - discussed here: https://news.ycombinator.
by simonw 3y ago
See also these unofficial interactive release notes: https://antonz.org/sqlite-3-44/ https://antonz.org/sqlite-3-44/ - discussed here: https://news.ycombinator.com/item?id=38095239 https://news.ycombinator.com/item?id=38095239
My favourite new feature is order by in aggregates, e.g.
select group_concat(name order by name desc)
- _a_a_a_ 3y agoUmm, isn't htat what 'over' is for? From memory (prob wrong but close enough) select string_concat(name) over (order by name) from ...
- deleted 3y ago[deleted]
- simonw 3y agoThat's for window functions, which work differently from aggregate functions.
- _a_a_a_ 3y agoIn MS SQL they are used together although I don't know if this is the standard. eg. SELECT city, STRING_AGG(email,';') WITHIN GROUP (ORDER BY email) email_list FROM sales.customers GROUP BY city; https://www.sqlservertutorial.net/sql-server-string-functions/sql-server-string_agg-function/ https://www.sqlservertutorial.net/sql-server-string-function... But even this isn't using the OVER() clause as I remembered. I'm a bit confused about what the standard is, if there is one. Anyway thanks.
- kaptainscarlet 3y agoI find group concat very useful when I want to aggregate foreign keys as an attribute in the parent row of an 1-N relationship