/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 vote413 views1 answer
Sql alternative to max statement
SQL
2 votes339 views2 answers
Laravel query builder toSql
SQL
4 votes351 views2 answers
Oracle last day of month
SQL
0 vote382 views1 answer
Amount of entries in a table psql
SQL
1 vote358 views1 answer
Too many connections mysql
SQL
0 vote417 views1 answer
Min varias colunas spark sql
SQL
0 vote350 views1 answer
Set open file limit mac catalina mysql
SQL
6 votes341 views1 answer
Allsource oracle
SQL
0 vote376 views1 answer
Sql select upcoming birthdays
SQL
0 vote319 views1 answer
Postgres get running query
SQL