Doug,

I understand that this is an old thread, but this topic was discussed today on another forum. See this solution
http://forums.asp.net/t/1362385.aspx

select [id],[name]

from test as A1

where (select count(*) from test as A2 where A2.[id]=A1.[id] and A2.name<=A1.name )<=2

order by [id]

>Hi,
>
>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.
>
>Regards
>Doug Johnston