SQL Server Paging problem

Environment

SQL Server 2008 R2

Problem

SQL Server Paging

Solve

Use test;  
--Creates a test table create  
table Test  
(  
    ID int primary key identity,  
    name varchar NOT null
);  
--Inserts data 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;  
--Performs the paging  
select top id,name from
test  
WHERE ID not in
        (SELECT top (0) ID from  
         test
  order by ID-  
      
select Id,name from test;  
      
--select Top PageSize * FROM TableName where ID. (SELECT top  pageSize * (pageNow-1) ID from 

tablename);

Screenshot of Running effect