已有 571 次阅读2014-6-24 16:42 | 斐波那契数列
一句sql实现斐波那契数列,据说是某公司的面试题
Select(Power((1+Sqrt(5))/2,number)-Power((1-Sqrt(5))/2,number))/Sqrt(5) As fb From Master.dbo.spt_values Where Type='P' And number Between 1 And 20
评论
|站长微信|Archiver|手机版|小黑屋|用友之家 ( 蜀ICP备07505338号|51072502110008 )
GMT+8, 2024-6-4 17:32 , Processed in 0.021371 second(s), 9 queries , Gzip On, Redis On.
Powered by Discuz! X3.5
© 2001-2024 Discuz! Team.