Session Ready
Exercise

Counting numbers recursively

In this first exercise after the video, we will start with a very simple math function. It is the simple series from 1 to target and in our case we set the target value to 50.

This means the task is to count from 1 to 50 using a recursive query. You have to define:

  1. the CTE with the definition of the anchor and recursive query and
  2. set the appropriate termination condition for the recursion
Instructions
100 XP
  • Limit the recursion step to 50 in the recursive query.
  • Define the CTE with the name counting_numbers.
  • Initialize number in the anchor query.
  • Add 1 to number each recursion step.