Data Analyst SQL Interview Questions | CONCAT function

Learn how to concatenate multiple rows into a single column with the CONCAT function. We will be bringing in full addresses from street, city, state and zip
#sqlinterview
#dataanalysis
#datascience
Learn and Practide SQL coding online at DataCamp, check out my affiliate link:
datacamp.pxf.i...

[@roshangangurde7188]

We can use concatws() Also to avoid adding space after each column

[@absentdata]

Nice recommendation. I will try it out

[@Yun_jung]

Very useful!!

[@friendsforever715]

Is this applicable to all RDBMS?

[@absentdata]

It was done in MS SQL Server Studio

[@adeel-videoeditor]

Great 👍😊