4 ms·
In MS SQL they are used together although I don't know if this is the standard. eg. SELECT city, STRING_AGG(email,';') WITHI
by _a_a_a_ 3y ago
In 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.