you can do this;

;

WITH

cteFindMax AS

(

SELECT ROW_NUMBER() OVER (PARTITION BY DetailsID, FollowupID ORDER BY FollowupID DESC) AS Occurance,

*

FROM [the name of your table]

)

SELECT *

FROM cteFindMax

WHERE Occurance = 1