Post reply

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

Viewing post 31 (of 30 total)

You must be logged in to reply to this topic. Login to reply