WHERE NOT EXISTS (SELECT 1 FROM tablename b WHERE b.Fid = a.id) START WITH Fid = 0 CONNECT BY PRIOR id=a.Fid)