/SQL/How to combine rows in sql server procedure

How to combine rows in sql server procedure

select id, a.name + coalesce('/'+b.name, '') + coalesce('/'+c.name, '')
from myTable a
left outer join myTable b on a.id=b.id and b.seqno = 2
left outer join myTable c on a.id=c.id and c.seqno = 3
where a.seqno = 1;

Source: stackoverflow.com

Similar codes

0 vote108 views1 answer
Sql truncate table referencing itself
SQL
-1 vote151 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote151 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
12 votes154 views4 answers
Mysql ifnull
SQL
0 vote164 views1 answer
Cannot pip install mysqlclient
SQL
0 vote157 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote176 views1 answer
MySQL import data from large CSV file
SQL
0 vote187 views1 answer
Download mysql database to excel in android studio
SQL
1 vote112 views1 answer
Enable mysql slow query log
SQL
10 votes170 views4 answers
Join multiple tables in sql
SQL