select top PAGESIZE * from components where id not in
(select top (PAGESIZE*(CURRENTPAGE-1)) 
id from components order by id)order by id

select top 10 * from components where id not in
(select top 10*10 id from components order by id)
order by id
从101条记录开始选择，只选择前面的10条记录

select * from components where id not 
in(select id from components where                
rownum<=(PAGESIZE*(CURRENTPAGE-1))) 
and rownum<=PAGESIZE order by id;

select * from components where id not in
(select id from components where rownum<=100) 
and rownum<=10 order by id;

select * from components where rownum
<=(PAGESIZE*(CURRENTPAGE-1)) minus 
select * from components where rownum
<=(PAGESIZE*(CURRENTPAGE-2));
如例：select * from components where 
rownum<=10 minus select * from components 
where rownum<=5;.

select * from (select rownum tid,components.
* from components where rownum<=100) where tid<=10;