/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 vote198 views1 answer
Check if string is a number sql
SQL
0 vote247 views3 answers
Constraint sql
SQL
3 votes208 views2 answers
Sqlite print all column names
SQL
0 vote192 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote193 views1 answer
Mysql select distinct date from timestamp
SQL
1 vote233 views1 answer
Mysql show long running queries
SQL
0 vote217 views2 answers
SQL Server Standard
SQL
0 vote199 views1 answer
Show size of all tables postgres
SQL
2 votes237 views1 answer
Orcale index size
SQL
0 vote208 views1 answer
Mysql drop trigger
SQL