// 方法一(对象法)
select *from(select *, number =row_number()over(order
by date desc)from Students )
m where number =2//方法二(排除法)
select top 1*from Students
where date not in( select top 1 date from Students )
SQL Server获取指定行(如第二行)的数据// 方法一(对象法)select * from (select * , number = row_number() over(order by date desc) from Students ) m where number = 2//方法二(排除法) select top 1 * from Students where date not in ( select top 1 date from St