/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

5 votes112 views1 answer
Sysdate in oracle sql
SQL
0 vote117 views1 answer
Heidisql check how much space a row
SQL
0 vote123 views1 answer
Postgresql in vs any performance
SQL
8 votes121 views2 answers
Sqlsrv default port
SQL
1 vote114 views1 answer
Loading local data is disabled mysql
SQL
0 vote168 views1 answer
Selecting from a view SQL
SQL
0 vote112 views2 answers
Plsql regex match whole word
SQL
3 votes112 views1 answer
Index using in query plsql
SQL
1 vote115 views3 answers
Getdate function in postgresql
SQL
8 votes126 views1 answer
Oracle add datafile to tablespace
SQL