>>Hi,
>>
>>Than I am afraid the problem is still unsolved as also the solution as per Message 1129692 results with the 2 records team 'DDDD' which do not meet the condition > 2. and solution as per Message 1129782 result in 4 records team 'BBBB" which do not meet the condition top 3
>>
>>Still looking for the correct VFP SQL syntax.
>>
>>Regards,
>>
>>Koen
>
>See also http://www.kodyaz.com/articles/top-n-random-rows-foreach-category-or-group.aspx

BTW, I tried various combinations myself (including this one) and none worked in VFP except the solution posted by Sergey.