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

IDGO 426 Reputation points
2022-06-02T05:21:26.397+00:00

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

207720-image.png

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 ..

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,588 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,131 questions
{count} votes

Accepted answer
  1. Jingyang Li 4,521 Reputation points
    2022-06-02T15:38:13.73+00:00
    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
    

0 additional answers

Sort by: Most helpful