TSQL Beginners Challenge 3 - Find the Factorial - Solution to TSQL Beginners Challenge3

Getting Started with Adobe After Effects - Part 6: Motion Blur


	TSQL Beginners Challenges

Upload Image

Close it

Select File

This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers


	Like

Invite Friends

TSQL Beginners Challenge 3 - Find the Factorial

Home · Challenge Details · Comments · Solutions · Fans (71) · Preferences

Solution to TSQL Beginners Challenge3

Sep 28 2011 11:03AM by rventoso

Solution to TSQL Beginners Challenge 3

with cte_fact as
(
	select 0 as Nums , 1 as fact
	union all
	select Nums+1, fact*(Nums+1)
	from cte_fact
	where Nums < 10	
)
select distinct Nums, fact 
from cte_fact     
where Nums in (0,1,3,5,10)

Tags:

rventoso

1911 · 0% · 9

Liked


Post this to my facebook wall
Tweet this
Like this


	Submit

Your Comment

Sign Up or Login to post a comment.

TSQL Beginners Challenge 3 - Find the Factorial

Solution to TSQL Beginners Challenge3

Your Comment