How to generate Fibonacci Series

sql, sql-server

Solution

Try this !

declare @a int
declare @b int
declare @c int
Declare @i int

set @a=0
set @b=1
set @i=0
set @c=0
Print 'Fibonacci Series'
print @a
print @b
while @i<10 
Begin
set @c=@a+@b
print @c
set @i=@i+1
set @a=@b
set @b=@c
end

Outputs !

Fibonacci Series

0 1 1 2 3 5 8 13 21 34 55 89

Problem

How to Generate Fibonacci series in sql ! I need to generate Fibonacci series 0 1 1 2 3 5 8 13 21 ... N I did this easily using C-code I need to do this using Sql !

Original source