SQL queries all subordinates of an infinite hierarchy, all superiors

Table1 table with infinite hierarchy, ID (primary key), ParentID (parent ID) queries all subordinates or all ancestors of an ID, using the WITH as,union all query

1, the query ID is 1 all subordinate

 withT as(     SELECT *  fromTable1WHEREId=1    UNION  All     SELECTA.*   fromTable1 AINNER JOINT onA.parentid=t.id)SELECT *  fromT

2, the query ID is 88 all the superior

 withT as(     SELECT *  fromTable1WHEREId= the    UNION  All     SELECTA.*       fromTable1 AINNER JOINT ona.ID=T.parentid)SELECT *  fromT

SQL queries all subordinates of an infinite hierarchy, all superiors