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
>>

>>>