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/
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/