grouping id with string value instead integer SQL GROUP BY

Question

On Google I just found group by sum (integer value). How can I group by a string value? For the table:

No   Place    Car 
---  ------   --------
1    NY       VRM1
1    BT       VLI
2    NY       GAR
3    GT       GAR

How can I group by 'No'? I tried:

SELECT No, place, Car 
FROM  APPEL
GROUP BY No, Place, Car

But it didn't work.

I want to have a table like this

No   Place    Car 
---  ------   --------
1    NY,BT    VRM1,VLI
2    NY       GAR
3    GT       GAR

possible duplicate of SQL SERVER Query result in CSV format is possible?. or this stackoverflow.com/q/446783/27535 — gbn
– gbn, Commented May 14, 2011 at 9:08

Mikael Eriksson · Accepted Answer · 2011-05-14 09:58:41Z

4

-- Sample data
with T (No,   Place,    Car) as
(
select 1,    'NY',       'VRM1' union all
select 1,    'BT',       'VLI' union all
select 2,    'NY',       'GAR' union all
select 3,    'GT',       'GAR'
)

-- The query
select
  T.No,
  stuff((select ','+T2.Place
         from T as T2 
         where T.No = T2.No
         for xml path(''), type).value('.', 'nvarchar(max)'), 1, 1, '') as Place,
  stuff((select ','+T2.Car
         from T as T2 
         where T.No = T2.No
         for xml path(''), type).value('.', 'nvarchar(max)'), 1, 1, '') as Car
from T
group by T.No

answered May 14, 2011 at 9:58

Mikael Eriksson

139k22 gold badges223 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

grouping id with string value instead integer SQL GROUP BY

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related