SQL server 取3-5之间的数据

SELECT TOP 3 Start_Date, End_Date FROM dbo.Scheme_Period
where id not in (SELECT TOP 2 id FROM dbo.Scheme_Period ORDER BY Start_Date DESC) ORDER BY Start_Date DESC;

必须有个唯一的值，比如id

http://blog.163.com/t_txst/blog/static/925632762010113394355/