SQL Pattern Generation | Generating the Right half Pyramid pattern | Recursive CTE

In this SQL problem solving session, we work to generate right-half pyramid pattern using recursive CTE.

Generating series of numbers:

#sql #sqlprogramming #sqlqueries #interview #problemsolving #patternmaking

[PriyasEra]

WITH RECURSIVE my_cte AS (
SELECT 1 n
UNION ALL
SELECT n+1 AS n FROM my_cte WHERE n<5
)
SELECT REPLICATE("*" , n) pattern
FROM my_cte; what is the error in this code xan you please tell me sir

[PriyasEra]

I am getting error like table cte doesn't exist