Parent Child Relation in same Table . Select Query to get only parent records and Records not comes under parent child relation
SELECT t1.*
FROM "table" t1
WHERE t1.parent IS NULL
  AND /* NOT */ EXISTS (SELECT 1
                        FROM "table" t2
                        WHERE t1.id = t2.parent)


EXISTS - for parent records.

NOT EXISTS - for single records.