Youtor
StringAgg Function in SQL Server how to get comma separated values in sql
YOUR LINK HERE:
http://youtube.com/watch?v=4-H5kz40zwA
Sql server interview video link : • how to get comma separated values in ... • Sccript:- • CREATE TABLE StringAgg_Tbl(id int,name char(3)) • INSERT INTO StringAgg_Tbl VALUES (1,'CD') • ,(1,'AB') • ,(2,'LM') • ,(3,'BC') • ,(3,'GH') • ,(4,'KJ') • ,(3,'AB') • • • SELECT id, • STRING_AGG (name, ',') AS data • FROM StringAgg_Tbl • GROUP BY id; • • SELECT id, • STRING_AGG (name, ',') WITHIN GROUP (ORDER BY name ASC) AS data • FROM StringAgg_Tbl • GROUP BY id; • • DROP TABLE StringAgg_Tbl • • • Find Us On YouTube- Subscribe Channel to watch Database related videos / @ssunitech6890 • For SQL Quiz- • • sql server : Interview Quiz | sql ser... • • Find Us On FaceBook- • / ss-unitech-187705388674384
#############################
