/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 vote192 views1 answer
Sql select random procentage from rows
SQL
1 vote241 views1 answer
Tsql create unique index composite
SQL
0 vote247 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote289 views1 answer
Sql server query all database objects
SQL
0 vote169 views2 answers
Get top 1 row of each group
SQL
2 votes245 views2 answers
Null column to 0 in mysql
SQL
10 votes342 views4 answers
Mysql if else
SQL
0 vote189 views1 answer
How to use lower case in mysql
SQL
0 vote183 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote220 views1 answer
Oracle columns table
SQL