Question

select 字段名 from 表明 order by 字段名，我想知道用什么关键字，可以让他只显示第2行

Answer 1

select * from students where ids=(select top 1 ids from students where ids in (select top 2 ids from students order by ids) order by ids desc)
有很多方法吧