3 ms·
Umm, isn't htat what 'over' is for? From memory (prob wrong but close enough) select string_concat(name) over (order by name) from ...
by _a_a_a_ 3y ago
Umm, 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.