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
>
>I have a VFP table with the following structure...
>
>idnum
>keyword
>cgroup
>iscore
>
>...I have one SQL statement that gets the top 20 percent (iscore) of all records (100 records returns 20), and this works fine...
>
>SELECT TOP 20 PERCENT,* FROM Table ORDER BY iscore
>
>I am now trying to get the top 20 percent (iscore) of each group (cgroup) and am struggling for the correct SQL syntax.
--sb--