Sep 25, 2024
WITH
clause followed by RECURSIVE
keyword.SELECT 1 AS n
SELECT n + 1 FROM numbers WHERE n < 10
manager_id
in employee details.RECURSIVE
, can use UNION
.UNION ALL
, no RECURSIVE
keyword.UNION ALL
instead of UNION
.RECURSIVE
keyword; needs explicit column aliases for the query.