It will be helpful having DDL, sample data, an expected result. That way we do not have to guess column names, data types, etc.

Help us to be able to help you!

You can join back the result of the CTE with the original table by the column in common or you can try deleting from the CTE if the conditions to use a CTE as the source are meet.