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
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
Replies
You are reading an archived discussion.
Related Posts
All the innovation that seems to be happening across various engineering disciplines; more so in electronics & computing domain seems to be incremental feature upgrades; and nothing 'breakthrough' sorts. We...
Lenovo has brought to the market a new convertible laptop called Lenovo IdeaPad A10 - which is the company's first to run on Android 4.2 Jelly Bean OS. At 1...
Ever since beginning our journey in 2005 we've had a lot of fun, excitement, moments of success along with ups & downs; all behind the scenes. As of writing this...
In this we can clean, it means we can delete all unwanted items as well as we can get more space of that disk(C Disk)..
Steps are as Follow:-
1....
Here's a short guide on how to opt out of email via Google+ - the latest feature announced by Google that allows anyone in your circles to send emails to...