Skip to content
RED SAGSkills
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;
Choose one answer