Question

怎么用sql语句写第三到第五名

Answer 1

Select top 3 * from (Select top 5 from table order by 排序字段) order by 排序字段 desc

Answer 2

select * from tablename skip(1).take(4)

Answer 3

select 字段名 from 表名 limit 2,2;