/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 vote274 views1 answer
Split first name and last name in sql
SQL
1 vote198 views3 answers
Mariadb add foreign key
SQL
0 vote208 views1 answer
Window function to forward fill
SQL
1 vote181 views1 answer
Postgresql update auto_increment value
SQL
2 votes206 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote216 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
6 votes221 views2 answers
Postgresql database url
SQL
0 vote196 views1 answer
How to check if there is no database schema
SQL
0 vote181 views1 answer
Postgres create database if not exists
SQL
1 vote184 views1 answer
Minus vs intersect in sql
SQL