/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 vote108 views1 answer
Trim sql oracle
SQL
0 vote117 views1 answer
Setval in postgres
SQL
1 vote148 views1 answer
Oracle create program if not exists
SQL
0 vote154 views1 answer
Split first name and last name in sql
SQL
0 vote123 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
2 votes118 views1 answer
Oracle sql query to make column data uppercase
SQL
3 votes118 views1 answer
Oracle apex call duration
SQL
1 vote115 views1 answer
Mysql not supported auth mode
SQL
7 votes126 views1 answer
Query postgres delete duplicates
SQL
3 votes136 views2 answers
Oracle drop sequence
SQL