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

Diese Übung ist Teil des Kurses

Hierarchical and Recursive Queries in SQL Server

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung zum Anfassen

Probieren Sie diese Übung aus, indem Sie diesen Beispielcode ausführen.

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

Bearbeiten und Ausführen von Code