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
Need SQL Query for unique constraint 2 columns take all Min date except Max Date
Indudhar Gowda
426
Reputation points
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 ..
Accepted answer
-
Jingyang Li 5,891 Reputation points
2022-06-02T15:38:13.73+00:00