/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 vote110 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes102 views1 answer
Sql find missing values between two tables
SQL
0 vote106 views1 answer
Sqlite update only if greater
SQL
3 votes224 views6 answers
Sql unique select
SQL
25 votes124 views6 answers
How to change column name in mysql
SQL
0 vote129 views1 answer
Nuget sqllite-net-pcl
SQL
1 vote152 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote110 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote110 views2 answers
Oracle create synonym
SQL
0 vote110 views1 answer
Mysql command prompt date insert format
SQL