Question

用sqlserver实现分页的语句

SELECT top id,name,pass FROM person WHERE id NOT IN (SELECT top "+(currentPage-1)*lineSize+" id FROM person
我是这样写的，读不出东西来，这句应该怎么写？
【我改成这样就能读出来了。说明别的语句应该没错。
SELECT id,name,pass FROM person】

Answer 1

给你一个参考
String sql ="select top 5 * from bean where id not in (select top "+5*(pageNum-1)+" id from bean order by id)";

Answer 2

(SELECT top "+(currentPage-1)*lineSize+" id FROM person"

改为
(SELECT top "+(currentPage-1)*lineSize+" * FROM person)"

试试

有问题欢迎发消息联络