Question

，sqlserver数据库，查询表A 中id 31至40的所有信息，id为自动增长，注意有可能不是连续的。怎么写sql语句

Answer 1

select 字段 from A where id between 31 and 40;

Answer 2

select * from A where id>30 and id<=40

Answer 3

分页的写法：
select top 10 * from A where id not in (select top 30 id from A order by id) order by id
普通写法：
select * from A where id between 31 and 40