SQL Server queries parent-child relationships

From the top-down query method, query out itself and all descendant data:

--as(Selectfromwhere ID= Select  fromwhere t.parentid=m.id)Select from Maco ORDER BY ID Desc

From the bottom up query, query out itself and all the direct ancestors:

--as(Selectfromwhere id=Select  fromwhere t.id=m.parentid)Select from Maco ORDER by ID

Delete yourself and all descendant data:

 as (Selectfromwhere id=,select from  where t.parentid=from thewhereinselect from Maco GROUP BY ID)

SQL Server queries parent-child relationships