Same EMployee have 5 recrods to get only one record.

 

WITH RankedRecords AS (

    SELECT 

        *,

        ROW_NUMBER() OVER (PARTITION BY AppraisalID ORDER BY ModifiedDate) AS RowNum

    FROM 

        tbl_EmpCompetencies

)

SELECT *

FROM RankedRecords

WHERE RowNum = 1;