Question

SQL SERVER如何提取前5条到前10条的纪录？

Answer 1

select top 10 * from 表 where id in (select top 5 id from titles) order by id desc

这句的意思是找前十条数据的id为titles表的前五条id的数据，按降序排列