摘要： --SQL Server获取指定行(如第二行)的数据----法一(对象法)--select * from( select * , number = row_number() over(order by Grade desc) from Students ) m where number = 2--法二(排除法)---select top 1 * from Studentswhere Grade not in( select top 1 Grade from Students) 阅读全文