从表中依次取出1-300行,301-600行这样数据存入新表中,sql语句怎么写?

[君立]

请教:从表中依次取出1-300行,301-600行这样数据存入新表中,sql语句怎么写?
select * from (select top 300 * from (select top ( 1 * 300 ) * from [new] order by [Col001])
order by [Col001] desc) order by [Col001]
但是发现上面语句top 在sql server 2005 中可以使用, 在2000版本中报错!
请问还有什么好语句实现以上功能

[kk19840210]

select top 300 * from [new] where [Col001] not in (select top 300 [Col001] from [new] order   by   [Col001])) order   by   [Col001])

[kk19840210]

select top 300 * from [new] where [Col001] not in (select top 300 [Col001] from [new] order   by   [Col001]) order   by   [Col001]

[-狙击手-]

create table new(id int,col001 char(20))
go

select   *   from   
(select   top   300   *   from   (select   top   300   *   from   [new]   order   by   [Col001]) aaa
      order   by   [Col001]   desc) bbb  order   by   [Col001] 


drop table new

[中国风]

--有唯一列时，用唯一列没有时用binary_checksum校验值所有列
--取301-600，按顺序小到大排列
select *
from
(select top 300 * from T where binary_checksum(*) not in(select top 300 binary_check(*) from T order by [Col001] desc ) order by [Col001] desc) TT
order by [Col001]

[yuyuelong1975]

如果是sql2005，可以用row_number()来写：
WITH temp AS
(SELECT *,ROW_NUMBER() OVER (order by 排序名称)as RowNumber
FROM 表名 )
SELECT *
FROM temp
WHERE RowNumber between 301 and 600
要继续往下排，改变301和600就可以了

[中国风]

select 
	*
from 
	(select 
		top 300 *
	from 
		(select   top  600 * from   T   order   by   [Col001]   desc   ) T1
	order by  [Col001]  asc)T2
order by [Col001] desc--加多一次排序

[烟云1]

写一个递归的函数可以处理。具体可以查一下网上SQL的递归函数方法吧