1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

Create the alphabet recursively

The task of this exercise is to create the alphabet by using a recursive CTE.

To solve this task, you need to know that you can represent the letters from A to Z by a series of numbers from 65 to 90. Accordingly, A is represented by 65 and C by 67. The function char(number) can be used to convert a number its corresponding letter.

Instructions

100 XP
  • Initialize number_of_letter to the number representing the letter A.
  • Increase the value of number_of_letter by 1 in each step and set the limit to 90, the value of Z.
  • Select the recursive member from the defined CTE.