Home Forums SQL Server 7,2000 T-SQL Connect By Prior RE: Connect By Prior
ramgbile
Valued Member
Points: 61
More actions
April 24, 2013 at 10:09 am
#1609614
WITH n(id, name) AS
(SELECT id, name
FROM tulieu
WHERE parent = 44
UNION ALL
SELECT m.id, m.name
FROM tulieu as m, n
WHERE n.id = m.parent)
SELECT * FROM n