/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

3 votes219 views2 answers
Oracle sql drop sequence
SQL
0 vote307 views1 answer
Mysql get longest string in column
SQL
5 votes239 views1 answer
JBDC
SQL
0 vote251 views1 answer
Sql decimal to 2 places
SQL
0 vote238 views1 answer
Mysql select field if condition
SQL
0 vote233 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote258 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote227 views1 answer
Check psql validity function
SQL
1 vote233 views1 answer
Postgres first_value in gropby
SQL
0 vote221 views1 answer
Install mysql 8 linux
SQL