how to get comma separated values in sql | sql server interview questions and answers | sql server

#ssunitech #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #sqlInterviewQuestionsForTesting
how to get comma separated values in sql | sql server interview questions and answers | sql server
-Scripts-
Create Table Comma_Separated_Tbl
(
TrainingId Int ,
Training varchar(100),
Classroom varchar(100),
StartTime Time,
duration numeric(14,2),
wk varchar(10)
)
Insert Comma_Separated_Tbl
Select 1,'SQL Server','Silver Room','10:00',2.00,'M'
Union
Select 2,'SQL Server','Silver Room','10:00',2.00,'W'
UNION
Select 3,'SQL Server','Silver Room','10:00',2.00,'T'
Union
Select 4,'SQL Server','Silver Room','10:00',2.00,'F'
UNION
Select 5,'MSBI','GOLD Room','11:00',1.45,'F'
Union
Select 6,'MSBI','GOLD Room','11:00',1.45,'M'
Union
Select 7,'MSBI','GOLD Room','11:00',1.45,'TH'
Select *
from Comma_Separated_Tbl
SELECT DISTINCT Training,Classroom,StartTime,duration,STUFF(
(SELECT ',' + wk FROM Comma_Separated_Tbl
WHERE Training=A.Training FOR XML PATH ('')), 1, 1, ''
)
FROM Comma_Separated_Tbl AS A
Find Us On KZbin- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For Quiz-
• sql server : Interview...
Find Us On FaceBook-
/ ss-unitech-18770538867...

[@scrt1111]

Nice ..Information share...Thanks

[@ssunitech6890]

Thanks for your appreciation

[@mariapradeepm]

Thanks so much, it's really helpful. Duration is not giving aggregated values for 3 days. We need to use Sum and group by to solve this! Hope that's not the idea for this session but thought of sharing.

[@ssunitech6890]

Thanks for your suggestion. Keep watching and commenting. Thanks again

[@AK-rw8zq]

I think we can use Wk+',' like this can give comma after the first week in the table...How we can do the reverse of the query comma separate values into new rows. Good approach and nice explanation.

[@ssunitech6890]

Yes right Ak. For a single problem we have multiple solutions. Thanks-SS Unitech

[@sairamprasadg8838]

select Training,Classroom,StartTime,duration, STRING_AGG(wk,',') from Comma_Separated_Tbl group by Training,Classroom,StartTime,duration This is the simplest one

[@ssunitech6890]

Yup this is also good one. Thanks-SS Unitech

[@devi.elvira]

I tried in SQL server, but not working

[@gordonpeplinski8293]

thank you for helping me fix my code

[@ssunitech6890]

Thanks, Please share to others

[@shubhangiagarwal3327]

Very nice video... waiting for the next...

[@ssunitech6890]

Thanks dear 🙏, Sure you will get every Saturday

[@lokesh2635]

Tq so much bro , u saved me just now I got dis question 👍👍👍

[@ssunitech6890]

Great 👍. Can you please share the videos to your friends

[@p.vsingh2876]

Excellent video sir

[@ssunitech6890]

Thanks dear 🙏

[@hosseinabbasabadi1471]

great video

[@ssunitech6890]

Thanks 🙏

[@roblynch99]

nice approach

[@ssunitech6890]

Thanks Rob. Please share to others

[@chandrakumarreddyvennapusa7806]

Wonderfull sir Thank you so much for sharing information:)

[@ssunitech6890]

Thanks. Please share to others

[@chandrakumarreddyvennapusa7806]

Sure sir 👌👍👍👌👍👌

[@ramprakash7883]

Very common interview question..

[@ssunitech6890]

Thanks dear 🙏

[@maheshkumar-vn6sn]

Really appreciate!! Thanks for sharing..

[@ssunitech6890]

Thanks dear 🙏

[@jaideepmalik1028]

Good

[@ssunitech6890]

Thanks dear 🙏

[@rs6559]

Helped A Lot..Thanks

[@ssunitech6890]

Thanks a lot please share to others..

[@SumitSingh-su3oh]

Great👌

[@ssunitech6890]

Thanks dear 🙏

[@sunnyverma419]

Great video, really helpful

[@ssunitech6890]

Thanks Sunny..

[@123amouri]

Thank you! You are a good teacher

[@ssunitech6890]

Thanks dear 👍 Please share to others

[@vaibhavsingh4043]

Awesome video... It should get more views and likes👍👍

[@ssunitech6890]

Thanks for these appreciating words..

[@supervisiongameplay]

Good explanation! It should get more views and likes..

[@ssunitech6890]

Thanks dear 🙏

[@pravaspatra3849]

Nice video sir.

[@ssunitech6890]

Thanks pravas for your continuous watching and appreciation..

[@BimleshKumar-iw5jn]

Helpful video..

[@ssunitech6890]

Thanks dear 🙏

[@jyothiprasadkr6189]

sir, its a really helpful videos for SQL server Interview preparation . Can we use STRING_AGG function to get this output ?

[@ssunitech6890]

Yes you can use but old version of SQL server we didn't have this function. It works only lattest versions. Thanks

[@naveenreddym6222]

How to use string agg here?

[@ssunitech6890]

String Agg cannot used in this case. I have recored a video on string agg

[@ankitagrawal4492]

I think by group by other columns then using string_aggr function will work in this case

[@ssunitech6890]

Not sure because didn't check will check and confirm Thanks

[@chaitanya2725]

Thank you so much for sharing this 😊

[@ssunitech6890]

Thanks for your appreciation 😘

[@Confidential007.]

Good explanation..

[@ssunitech6890]

Thanks dear 🙏

[@maheshkumar-vn6sn]

Nice video

[@ssunitech6890]

Thanks dear 🙏

[@rajeshkumar912]

Complex but helpful..

[@ssunitech6890]

Thanks dear 🙏

[@gagandeepsingh6126]

Awesome

[@ssunitech6890]

Thanks dear 🙏

[@ambikakheny3857]

What if i have to find delimiter present in the table ? Can i use xml logic

[@ssunitech6890]

Yes

[@ambikakheny3857]

I have tried using xml sir, it didn't work for me ..can you Please explain here

[@ssunitech6890]

Let's connect on whatsapp

[@saketshrivastava7346]

Awesome Video ....it's a request can you upload all important interview questions in one vedio if possible .. I follow and see all your videos and it's very helpful in my SQl related skills

[@ssunitech6890]

Thanks Saket for your continuous appreciation! If I merge all the questions then that would be very big video...

[@nitagawade3330]

excellent!!

[@ssunitech6890]

Thanks Nita... Please share to others

[@Tocy777isback0414]

Thank you so much!!!!

[@ssunitech6890]

Wc. Please share to others

[@benjolopez6042]

Thank you for sharing

[@ssunitech6890]

Thanks Benjo.. Please share to others

[@ShivamKashyap-il7jl]

Sir if the output 0f this tutorial consider as a input and want the output like tutorial query Than how we solve this problem

[@ssunitech6890]

Will let know..

[@gagandeepsingh6126]

One more thing please post queries regarding to videos on your facebook page or blog for practice purpose.

[@ssunitech6890]

Sure I will upload on our Facebook page..

[@esmailpaltasingh2073]

How to achieve this same in presto database Sir

[@ssunitech6890]

Sorry brother, I don't have any idea

[@esmailpaltasingh2073]

@@ssunitech6890 ok

[@deepakjain5071]

Gud video

[@ssunitech6890]

Thanks dear 🙏

[@mahanteshchougala1693]

Training clsrm start-time duration wk SQl. Silver. 10. 3. M T W F Bro...tell me how to display like this

[@ArshadKhan-hh7gf]

distinct command is not working at last🤷‍♂

[@ssunitech6890]

Why??

[@ArshadKhan-hh7gf]

@@ssunitech6890 I don't know sir. Have you any other command?

[@rohitsethi5696]

where is the script

[@ssunitech6890]

Will add script in description of the video

[@mrrish1401]

there is no scripts in fb please provide that scripts also

[@ssunitech6890]

Thanks dear, I was thinking I added scripts on each video's description.. thanks for letting me know.. Please check the description of the video. Thanks-SS Unitech

[@ssunitech9252]

It's very common interview questions, I was waiting for it. Thanks for sharing..

[@ssunitech6890]

Thanks Sandhya for your continuous appreciations...

[@pawanpal729]

Good

[@ssunitech6890]

Thanks dear 🙏

[@maheshkumar-vn6sn]

Nice video

[@ssunitech6890]

Thanks dear 🙏