Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Duplicates RE: Duplicates

  • March 3, 2015 at 12:45 am

    #1781274

    I think the correct answer should be -

    select * from (select lname , datemodified , ROW_NUMBER() over (PARTITION by lname,jobtitle order by datemodified desc) as 'ct' from #DuplicateRow) a where ct <2