/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 vote139 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote137 views1 answer
Rermove categories woocommerce sql
SQL
1 vote129 views1 answer
Mysql view command
SQL
62 votes176 views8 answers
Mysql add column
SQL
0 vote133 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote118 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
5 votes133 views2 answers
Sql server port number
SQL
10 votes124 views1 answer
Create table oracle
SQL
5 votes136 views1 answer
Commentaire table oracle
SQL
0 vote129 views1 answer
Oracle string length
SQL