Combine Multiple Rows into One Cell Using SQL

Is it work for oracle sql as well?

Great video. One suggestion... please consider either lowering or omitting the background music because I found it a bit distracting. Thank you, Anthony.

Do you perhaps know how to reverse this, i have a row with all the emails linked to the project in one cell separated by a ; i need to have all those emails listed each in a row and the project they dealt with

Will this work if i have it in views and there are alot of inner joins ?

Thank you Anthony. I’m learning SQL, Tableau, and Python right now and your videos are so helpful!❤

hello there, god bless your efforts..I have a simple enquiry as new sql learner.
How are CTEs different from temporary tables?
Thanks for taking care of this.