Counting numbers recursively

In this first exercise, you will start with a math function to count numbers recursively. It is the series from 1 to target and in this case your target value is 50.

This means the task is to count from 1 to 50 using a recursive query. The video showed you the pseudo-code version, and now it's your turn to write it in real code! You will have to define:

The CTE with the definition of the initial and recursive query
The appropriate termination condition for the recursion

Este exercício faz parte do curso

Hierarchical and Recursive Queries in SQL Server

Ver Curso

Instruções de exercício

Define the CTE with the name counting_numbers.
Initialize number in the initial query.
Add 1 to number each recursion step.
Limit the recursion step to 50 in the recursive query.

Exercício interativo prático

Experimente este exercício preenchendo este código de exemplo.

-- Define the CTE
___ ___ ___ ( 
	SELECT 
  		-- Initialize number
  		___ AS number
  	UNION ALL 
  	SELECT 
  		-- Increment number by 1
  		___ 
  	FROM counting_numbers
	-- Set the termination condition
  	WHERE number < ___)

SELECT number
FROM counting_numbers;

Editar e executar código