Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLrecursive CTEsSingle-choice MCQ

What sequence of values does column n take in this recursive CTE's result?

WITH RECURSIVE t(n) AS ( SELECT 1 UNION ALL SELECT n * 2 FROM t WHERE n < 20 ) SELECT n FROM t ORDER BY n;