SQL Server获取指定行(如第二行)的数据 --SQL Server获取指定行(如第二行)的数据-- --法一(对象法)-- select * from ( select * , number = row_number() over(order by Grade desc) from Students ) www.2cto.com m where number = 2 --法二(排除法)--- select top 1 * from Students where Grade not in ( select top 1 Grade from Students ) |