Skip to content

Instantly share code, notes, and snippets.

@youz

youz/fib.sql

Created July 13, 2012 04:05
Show Gist options
  • Save youz/3102660 to your computer and use it in GitHub Desktop.
Save youz/3102660 to your computer and use it in GitHub Desktop.
Download ZIP
再帰CTEでフィボナッチ数列
Raw
fib.sql
WITH fibs (fib, pre) AS (
SELECT 1, 0
UNION ALL
SELECT fib+pre, fib from fibs
)
SELECT TOP 40 fib FROM fibs;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment