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

How to achieve this same in presto database Sir

where is the script

distinct command is not working at last🤷‍♂

great video

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.

Nice ..Information share...Thanks

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

Thank you so much for sharing this 😊

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

Wonderfull sir Thank you so much for sharing information:)

nice approach

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

Thank you so much!!!!

Great video, really helpful

select Training,Classroom,StartTime,duration, STRING_AGG(wk,',')
from Comma_Separated_Tbl
group by Training,Classroom,StartTime,duration


This is the simplest one

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.

excellent!!

there is no scripts in fb please provide that scripts also

Thank you for sharing <3

Thank you! You are a good teacher

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

Helped A Lot..Thanks

Training clsrm start-time duration wk
SQl. Silver. 10. 3. M
T
W
F

Bro...tell me how to display like this

Nice video sir.

Nice video

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

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

Complex but helpful..

Good explanation..

Nice video

Good

Great👌

Good

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

Gud video

Excellent video sir

Very common interview question..

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

Helpful video..

Really appreciate!!
Thanks for sharing..

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

Awesome

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