@kanagavel-a-eJ4OGB
•
Oct 25, 2024
Oct 25, 2024
1.4K
Can anyone explain how this racursive CTE works?
with
factorial(n,fact)as
(
select
2,cast(2 asfloat)
union
all
select
n+1,(n+1)*fact
from
factorial
where
n<50
)
select
n,fact
from
factorial
