hard20 pts · first answer countssqlcte
Recursive CTE stopping point
What do COUNT(*) and MAX(x) return?
WITH RECURSIVE n(x) AS ( SELECT 1 UNION ALL SELECT x * 2 FROM n WHERE x < 50 ) SELECT COUNT(*), MAX(x) FROM n;
What do COUNT(*) and MAX(x) return?
WITH RECURSIVE n(x) AS ( SELECT 1 UNION ALL SELECT x * 2 FROM n WHERE x < 50 ) SELECT COUNT(*), MAX(x) FROM n;