Sql Server Some Question --Select Interzone(区间的) Data

----问题----
查找第10 - 20 的记录
declare @tb_1 table
(id int identity(1,1),
 name varchar(10)
)

declare @i int
set @i=0
while @i<20
begin
insert into @tb_1 select 'Name'+cast(@i as varchar(2))
set @i=@i+1
end

select * from @tb_1

---Get Data From record 11 to 20--
select top 20 * from @tb_1
where id not in
(select top 10 b.id from @tb_1 b)

---运行结果---
id          name      
----------- ----------
1           Name0
2           Name1
3           Name2
4           Name3
5           Name4
6           Name5
7           Name6
8           Name7
9           Name8
10          Name9
11          Name10
12          Name11
13          Name12
14          Name13
15          Name14
16          Name15
17          Name16
18          Name17
19          Name18
20          Name19

(20 row(s) affected)

id          name      
----------- ----------
11          Name10
12          Name11
13          Name12
14          Name13
15          Name14
16          Name15
17          Name16
18          Name17
19          Name18
20          Name19

(10 row(s) affected)