Too bad. It works fine in SQL Server.
>I tried your solution, but get "Queries of this sort are not supported" error.
>
>Regards
>Doug Johnston
>
>
>
>>Hi Doug,
>>
>>Assuming that idnum is PK for mytable
>>
>>SELECT * FROM mytable t1
>> WHERE idnum IN (SELECT TOP 20 PERCENT idnum FROM mytable WHERE cgroup = t1.cgroup ORDER BY iscore)
>>ORDER BY cgroup, iscore
>>
>>>
--sb--