sql 递归查询

递归父节点

with  diguifu as( select * from aaa where id=22union allselect aaa.* from diguifu, aaa where diguifu.PID = aaa.id)select * from diguifu

递归子节点

with diguizi as(select * from aaa where id=33   union all select aaa.* from diguizi, aaa where diguizi.id = aaa.pid)select * from diguizi