博客园-ADO.NET-最新评论http://www.cnblogs.com/lijunzaizi/CommentsRSS.aspxzh-cnWed, 08 Feb 2012 06:52:48 GMTWed, 08 Feb 2012 06:52:48 GMTcnblogsRe:1、1、2、3、5、8、13、21、34...... 求第30位数是多少， 用递归算法实现http://www.cnblogs.com/lijunzaizi/archive/2010/09/13/1384919.html#1915633女女Mon, 13 Sep 2010 11:25:09 GMThttp://www.cnblogs.com/lijunzaizi/archive/2010/09/13/1384919.html#1915633
女 2010-09-13 19:25 发表评论
]]>re: 天域精诚软件系统面试题总结http://www.cnblogs.com/lijunzaizi/archive/2009/02/12/1332957.html#1449506Gary GongGary GongThu, 12 Feb 2009 07:55:03 GMThttp://www.cnblogs.com/lijunzaizi/archive/2009/02/12/1332957.html#1449506
select top(40-31+1) * from table not in (select top(31-1) * from table)



用not in 似乎不太好吧.
我的算法是
select top 10 * from A
where id in
(select top 40 id from A
order by id DESC)

Gary Gong 2009-02-12 15:55 发表评论
]]>