Interview question

Select id,units=STUFF((select ','+ a.Units from tablename a where a.id=b.id)1,2,'') from tablename b group by id

+2

Hi,

Try this query:

+3

you can even SORT it

+1

Let me show you a different answer

If you are using SQL 2017

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017

+1

https://stackoverflow.com/questions/12668528/sql-server-group-by-clause-to-get-comma-separated-values This should help you

0