求助,这样的SQL语句怎样写,(100分)

--取出,前几条的记录,条件是 F02 >= 一定的值
--例:取出前几条F02和的>=300为止则取出,3条;取F02的和>=150 为止则取出2条,ORACLE,SQL怎样写
create Table A01
(
F01 number,
F02 number
)

insert into A01 values(1,100)
insert into A01 values(2,200)
insert into A01 values(3,210)
insert into A01 values(4,1210)
commit;

顶

没看明白，能表述清楚些么，最好举个实在的例子！

关注中。。我也想知道有什么好方法

用游标可以实现



declare @j int
declare @k int
declare @f int
set @f=0
declare i cursor for select f01,f02 from a01 order by f01
open i
fetch next from i into @j,@k
while(@@Fetch_STATUS=0)
begin
set @f=@f+@k
set @k=0
if @f>=150
Begin
select * from a01 where f01<=@j
break
End
fetch next from i into @j,@k
end
close i
deallocate i