Question

SQL 中 从一个表中读取第三条至第八条数据怎么写

假设表A 主键为 为 id 但id 不连续 按降序desc 从表中读取第三条至第八条数据怎么写

Answer 1

select top 6 * from 表名 where ID not in (select top 2 id from 表名 order by id desc) order by id desc

Answer 2

select * from A
order by id desc
limit 2,6

Answer 3

select row_number() over (order by id desc) as rowId,* from A where rowId between 3 and 8

Answer 4

select top 6 * from 表名 where ID not in (select top 2 id from 表名)