Home Forums SQL Server 2008 SQL Server Newbies Exclude duplicates, keep the value with the latest date RE: Exclude duplicates, keep the value with the latest date

  • February 26, 2013 at 3:39 am

    #1591096

    but If performance is in concern then go for

    select CandidateID, max(YourDateColumn)

    from YourTable

    group by CandidateID