I have a selfreferenced foreignkey table . Deleting records from this table is complicated.

I am using a CTE to fetch all child records to be deleted together to avoid foreign...