Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in MS SQL Server

Introduction
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

Instruction

Excellent. Let's do an additional exercise to practice.

Exercise

Create a recursive query that will show three columns:

  • Num – even numbers from 2 to 20 (inclusively),
  • NumPlusPrev – the current even number plus the previous even number,
  • NumSquare – the current even number squared.

Stuck? Here's a hint!

In order to get squared values, you may multiply the value by itself.