SQL server 2000 如何取得满足条件的记录子集

比如想取出表a中第50到第100之间的记录，表中并没有标志当前记录是第几条记录的字段，请问应该怎么实现？在Oracle中有rownum这样的伪列，不知道在ms sql中有没有相同功能的字段

---

SQL code:
--2005 row_number()
;with wufeng4552
as
(
select *,cnt=row_number()over (order by getdate())
)
select * from wufeng4552 where cnt between 50 and 100
--2000加自增列吧
alter table tb
add cnt int identity
go
select * from wufeng4552 where cnt between 50 and 100
go
alter table tb
drop column cnt

---

SELECT ROW_NUMBER() OVER (ORDER BY  ID ASC) AS ROWID, * from a

---

引用

SQL code--2005 row_number();with wufeng4552as
(select*,cnt=row_number()over (orderbygetdate())
)select*from wufeng4552where cntbetween50and100--2000加自增列吧altertable tbadd cntintidentitygoselect*from wu¡­

--2005 row_number()
SQL code:
;with wufeng4552
as
(
select *,cnt=row_number()over (order by getdate())
)
select * from wufeng4552 where cnt between 50 and 100
--2000加自增列吧
alter table tb
add cnt int identity
go
select * from tb where cnt between 50 and 100
go
alter table tb
drop column cnt

---

SQL code

---

Code highlighting produced by Actipro