r k

r k

  • 2k
  • 63
  • 1.8k

Sql Multirow in single row with line break

Jun 10 2021 9:11 PM

in my sql table 

id contents
1 My content in first column  
1 My content in second  column

 

I want these two rows same id's 1 ,1 in a single row in sql , But not concate with comma seperation rather i want one line with line break then second line so they will appear in the row with line break .Please help.

i want them per requirement as below

id  contents
1

My content in first column

My content in second column

 


Answers (1)