假设：pagecount=30 --每页显示的记录数Currentpage=3 --当前页码select top 30 ID,Title from bookswhere Publisheris =(....)and id not in (select top 30*(3-1) id from books where Publisherid =(...) order by id)order by id(...) 跟你那个一样，就不写了，两处都是一样的你的错误是在id not in中没有加那个（...）的条件...
