See the following Google Thread:

http://groups.google.com/groups?hl=en&ie=ISO-8859-1&oe=ISO-8859-1&threadm=372A0FA7.49BF291C%40elucidex.com&rnum=1&prev=/groups%3Fhl%3Den%26ie%3DISO-8859-1%26oe%3DISO-8859-1%26q%3DContactPersonsName%26btnG%3DGoogle%2BSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.*

>Is there a way, using a SQL query, to grab the first record within each group of records in a SQL query?
>
>I currently have the need to grab just the first record within each group of records where a group of records is defined by a SQL 'group by' clause and where a 'order by' clause determines what which record floats to the top of each group.
>
>Thank you!
>Malcolm Greene
>Brooks-Durham