Naomi,

did you test the statement? I get error "Invalid use of subquery"

with :

select  score , team ;
	from crResult as A1 ;
	where (select count(*) from crResult as A2 where A2.team=A1.team and A2.score<=A1.score ) <=2 ; 
	order by score

Regards,

Koen

P.S. My testdata consists of CREATE CURSOR crResult (team c(4), score n(2,0)) with values as per example given