La consulta de Oracle es:
select t3.id,
t4.caption || '>' || t3.caption
from (
SELECT t1.id as id,
(t2.caption || '>' || t1.caption) as caption,
t2.pid as pid
FROM ParentChild T1, ParentChild T2
WHERE T1.pid = T2.id(+)
) t3,
(
SELECT t1.id as id,
(t2.caption || '>' || t1.caption) as caption,
t2.pid as pid
FROM ParentChild T1, ParentChild T2
WHERE T1.pid = T2.id(+)
) t4
where t3.pid = t4.id(+);
Producción:
ID T4.CAPTION||'>'||T3.CAPTION
---------------------- ---------------------------
4 a>b>c>d
3 >a>b>c
1 >>a
2 >a>b
5 >a>e
Necesito la consulta de SQL Server equivalente ...
Intente seguir la consulta;)
SELECT t3.id, t4.caption + '>' + t3.caption
FROM (
SELECT t1.id as id, (t2.caption + '>' + t1.caption) as caption, t2.pid as pid
FROM ParentChild T1
LEFT JOIN ParentChild T2
ON T1.pid = T2.id) t3
LEFT JOIN (
SELECT t1.id as id, (t2.caption + '>' + t1.caption) as caption, t2.pid as pid
FROM ParentChild T1
LEFT JOIN ParentChild T2
ON T1.pid = T2.id) t4 ON t3.pid = t4.id;
Este artículo se recopila de Internet, indique la fuente cuando se vuelva a imprimir.
En caso de infracción, por favor [email protected] Eliminar
Déjame decir algunas palabras