Dupes: Need to merge them

[RyanNerd]

SELECT max(Id) as Id, max(FirstName) as FirstName, max(LastName) as LastName 
FROM RxChart.Resident 
GROUP BY DOB_YEAR, DOB_MONTH, DOB_DAY having count(*) > 1;