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

Cet exercice fait partie du cours

<cours>Hierarchical and Recursive Queries in SQL Server</cours>

Voir le cours

Instructions de l’exercice

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.

Exercice interactif pratique

Essayez cet exercice en complétant ce code d’exemple.

-- 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;

Modifier et exécuter le code