Use a CTE with a ROW_NUMBER() to return only those records with a ROW_NUMBER() = 1.

Since you haven't provided sample data to work with, I can't provide you tested code.

Drew