(Vikram Khatri) Say, you want to concatenate all rows of a column and show it as a single row in the same fashion aggregate function works.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help