/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 vote156 views1 answer
Sql runnignsum
SQL
1 vote183 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote193 views1 answer
Check database restore status sql script
SQL
1 vote183 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote221 views1 answer
Modifier une valeur sql
SQL
0 vote171 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
9 votes196 views3 answers
Mysql show table column full description
SQL
2 votes205 views2 answers
Calculate percentage in sql
SQL
0 vote172 views1 answer
Default value false mysql
SQL
0 vote175 views1 answer
No suitable driver found for sqlite
SQL