>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
Tim Westmoreland Software Engineer Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).