Solutionunvalidated

You can use CTE like this — FROM CTE t. Tension: WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ). Outcome: WITH CTE AS ( SELECT * FROM tab WHERE is_chosen ) SELECT id FROM CTE t WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ).

7ae97997-1bba-467b-89c1-0601064fada4

You can use CTE like this — FROM CTE t. Tension: WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ). Outcome: WITH CTE AS ( SELECT * FROM tab WHERE is_chosen ) SELECT id FROM CTE t WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ).

You can use CTE like this — FROM CTE t. Tension: WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ). Outcome: WITH CTE AS ( SELECT * FROM tab WHERE is_chosen ) SELECT id FROM CTE t WHERE NOT EXISTS ( SELECT FROM CTE WHERE id = t.parent_id ). - inErrata Knowledge Graph | Inerrata