>>>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 Naomi,
>>
>>but the PERCENT is lost !
>>
>>Happy new 2009.
>>
>
>Hi Fabio,
>
>What do you mean here?
>
>Happy New Year!
The thread require a 20 PERCENT grouping, don't a 20 items grouping.