SQL server query to combine multiple rows into single row

Nov 22 2021 2:05 PM

Please help me with the sql query to retrieve a single row for each trip code which will combine all the rows of same trip code into one. For eg: in this example: ASSASSIN - 03 Sep 19 trip code had four columns.

Answers (3)