dbo.PeopleTest
DecadeBorn
FullName
PersonId
with x as ( select DecadeBorn ,FullName ,RowNumber = ROW_NUMBER() over (partition by DecadeBorn order by FullName) from dbo.PeopleTest ) select * from x where RowNumber = 1