View Feed
group-icon
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12943 Members
Join this group to post and comment.
Kanagavel A
Kanagavel A • Jan 9, 2014

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

Share this content on your social channels -