select top 10 * from ComprehensiveShow where id not in(select top 40 id from ComprehensiveShow order by id)

意思是查询前40条数据，在查询不在前40条数据中的前10条数据

//select top 10 * from ComprehensiveShow where id not in(select top 10(1-1) id from ComprehensiveShow order by id)

//表示第一页 10(1-1)=0

 

 

 

select top 10 * from Base_Dict where DictID not in (select top 20 DictID from Base_Dict) and ParentID !=0

--查询不在前20条数据 的前10条数据 并且ParentID !=0

--