Can anyone explain how this racursive CTE works?

Kanagavel A
Kanagavel A
@kanagavel-a-eJ4OGB • Oct 25, 2024

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

Like 0 Replies 0

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform