Create Fibonacci sequenc

34-21-FibonacciBlocks

In SQL Server, You can create the fibonacci Seriense user the SQL Command.

— Fibonacci Series
;with fibo as (
select 1 as fibA, 1 as fibB, 1 as seed, 1 as  num
union all
select (seed + fibA)fibA , (fibA + fibB) fibB, fibA as seed, (num+1) as num
from fibo
where num<12
)
select fibA,fibB
from fibo

2 thoughts on “Create Fibonacci sequenc

Add yours

Leave a comment

Blog at WordPress.com.

Up ↑

Design a site like this with WordPress.com
Get started