SQL Tricks | Xmas Tree Pattern | Holiday Fun and Learn ! Recursive CTE #sqltips #sqlfordataengineer

In this SQL Tip, we write a SQL Query to create a Xmas Tree Pattern!
#sqltips #sqlfordataengineer
We also learn the concept of Recursive CTE to generate a sequence.

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[chinnadurai]

Hi Mam, I have tried the same but getting error in where clause ) symbol..pls help

[Shankar-ziyk]

set @x=1
set @y=10
while @x<10
begin
end;
another way of creating tree