一个简单的筛选查询 求助

[songguozhi]

create table t3(id int identity(1, 1), b int, dt datetime)

insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(3, getdate())
insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(4, getdate())
insert into t3(b, dt) values(6, getdate())
insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(2, getdate())

--查询从第一条记录开始 b字段之和小于6的所有记录

[昵称被占用了]

select * from t3
where (select sum(b) from t3 where id<=a.id)<6

[ws_hgo]

create table t3(id int identity(1, 1), b int, dt datetime)

insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(3, getdate())
insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(4, getdate())
insert into t3(b, dt) values(6, getdate())
insert into t3(b, dt) values(1, getdate())
insert into t3(b, dt) values(2, getdate())

select * from t3 t
where (select sum(b) from t3 where id<=t.id)<6]

id          b           dt
----------- ----------- -----------------------
1           1           2010-09-08 16:24:21.700
2           3           2010-09-08 16:24:21.700
3           1           2010-09-08 16:24:21.717

(3 行受影响)

[rucypli]

select * from t3 where b<6

[songguozhi]

[Quote=引用 1 楼 haiwer 的回复:]
SQL code
select * from t3
where (select sum(b) from t3 where id<=a.id)<6
[/Quote]

还有没有更好的办法，这样的话，数据记录达到100万时，就无法仍受了