2 ms·
That's for window functions, which work differently from aggregate functions.
by simonw 3y ago
That'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.