1
Answer

Sql Multirow in single row with line break

Photo of r k

r k

3y
676
1

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)