Column into row

• sks_989

  SSC Eights!

  Points: 843

  More actions

  March 4, 2022 at 9:33 pm

  #3993400

  i have table with onle column want to convert to row

  Table name - Test

  Column name field1

  data into table

  Filed1

  1

  2

  3

  I want output as 1,2,3

  There can mutiple record there is no fix so cannot d0 pviot

   

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  March 5, 2022 at 1:47 am

  #3993492

  look up STRING_AGG()