--第11条到第20条,共选出10条记录 select * from (select top 10 * from (select top 20 * from 表名 order by ID) t1 order by ID desc) t2 order by ID --或--第11条到第20条,共选出10条记录 select top 10 * from 表名 where ID>(select max(ID) from (select top 10 ID from 表名 order by ID) t1) order by ID
--一般是6-10條 select TOP 5 * from stu Where id Not In(Select TOP 5 id From stu) order by id;
修改下select TOP 5 * from stu Where id Not In(Select TOP 5 id From stu order by id) order by id;
或者select TOP 5 * from (Select TOP 10 * From stu order by id)A order by id Desc;
select *
from (select top 10 * from (select top 20 * from 表名 order by ID) t1 order by ID desc) t2
order by ID
--或--第11条到第20条,共选出10条记录
select top 10 *
from 表名
where ID>(select max(ID) from (select top 10 ID from 表名 order by ID) t1)
order by ID
select TOP 5 * from stu Where id Not In(Select TOP 5 id From stu) order by id;