@dwain.c

Thank you...it worked...:)

SELECT ID, FID, HC, VC, SN, updateddate

FROM

(

SELECT ID, FID, HC, VC, SN, updateddate

,rn=ROW_NUMBER() OVER (PARTITION BY HC, VC ORDER BY updateddate DESC, SN DESC, FID DESC)

FROM SampleData

) a

WHERE rn=1;