Question

asp+access 在数据库提取数据的时候，怎么从第二条或者第三条开始提取？

我用sql="select top 2 * from info where SmallClassName='1' order by ID desc"提取出来的是前面两条，而我要的是从第二条开始提取，不要第一条信息！

Answer 1

第二条
Select Top 10 * From info Where ID not in (Select Top 1 ID From info Order By ID desc) Order By ID desc
第三条
Select Top 10 * From info Where ID not in (Select Top 2 ID From info Order By ID desc) Order By ID desc

Answer 2

select top 2 * from info where SmallClassName='1' and ID<>1 order by ID desc

Answer 3

2楼的答案是正确的

Answer 4

select * from info where SmallClassName='1' and ID > 1 order by ID desc