SQL Server分页问题 - MSSQL教程

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,name
FROM 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);

运行效果截图

（编辑：佛山站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!