Need SQL Query for unique constraint 2 columns take all Min date except Max Date

Question

Need SQL Query for unique constraint 2 columns take all Min date and do not take Max Date.

In the Above Screen Shot.....Need SQL Query for [reportableresultcode] and [iscalculated] are unique constraint 2 columns, Take duplicates but dont take MAX Date.

Insert Duplicate Row's in TempTable.

I have attached the Excel sheet ..

Answer 1

SELECT 
[reportableresultid]
      ,[samplecode]
      ,[testprepetitioncode]
      ,[testcode]
      ,[parametercode]
      ,[reportableresultcode]
      ,[iscalculated]
      ,[createdonutc]
FROM (SELECT   [reportableresultid]
      ,[samplecode]
      ,[testprepetitioncode]
      ,[testcode]
      ,[parametercode]
      ,[reportableresultcode]
      ,[iscalculated]
      ,[createdonutc]
      ,row_number() Over(partition by reportableresultcode,  iscalculated  order by [createdonutc] desc) rn
  FROM  [dbo].[yourtablename]
  ) t
  where rn>1