/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 vote193 views1 answer
Mysql into outfile with headers
SQL
0 vote198 views1 answer
How to fetch data from database in sql
SQL
0 vote182 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote173 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote176 views1 answer
OstgreSQL version
SQL
0 vote191 views1 answer
Sql select min row
SQL
0 vote170 views1 answer
Procedure excute monthly oracle
SQL
0 vote132 views2 answers
Spring properties file for db
SQL
0 vote240 views1 answer
Sql filter rows with condition
SQL
24 votes162 views6 answers
Rename a column in sql server
SQL