select heirarchy

how do we fetch all the elements in a hierarchy below the element?
for example consider the following table
CompanyID  Name   ParentCompany
__________ ______ ______________
       1             A              NULL
       2             B                 1
       3             C                 1
       4             D              &n ...