Question

sql查询表A中某行数据

如何使用sql语句查询表A中第100行到150行的数据。假设里面都是有数据的。主键为ID
是查询特定行。不要说
select id
from A
where id>=100 and id<=150

再说一次。是查询行数。不是查询ID数

Answer 1

select * from A order by id asc limit 100,50;

倒序的是

select * from A order by id desc limit 100,50;

Answer 2

select * from
(
select top 51 * from
(
select top 150 * from [A] order by [id] asc
) as A1
order by [id] desc
) as A2
order by [id] asc

Answer 3

select top 51 * from (select top 150 * from A) AA order by id desc

Answer 4

select * from A
where ID between 100 and 150