SQL Server分頁問題

環境

SQLServer 2008 R2

問題

SQLServer分頁

解決

use test;  --建立測試表  create table test  (      id int primary key identity,      name varchar(20) not null);  --插入資料        insert into test(name) values('test1');        insert into test(name) values('test2');        insert into test(name) values('test3');        insert into test(name) values('test4');        insert into test(name) values('test5');        insert into test(name) values('test6');        insert into test(name) values('test7');        insert into test(name) values('test8');        insert into test(name) values('test9');        insert into test(name) values('test10');        select * from test;  --執行分頁  SELECT TOP 10 id,nameFROM test  WHERE id  NOT IN        (SELECT TOP (10 * 0) id           FROM test           ORDER BY id)  ORDER BY ID        select id,name from test;        --select top pageSize * from tableName where id not in (select top  pageSize * (pageNow - 1) id from tableName);

運行效果截圖