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