Viewing post 1 (of 2 total)
This seems simpler to me:
DELETE --or SELECT *
FROM #DuplicateRow
WHERE JobTitle = 'Editor' and datemodified < (SELECT MAX(datemodified) FROM #DuplicateRow WHERE JobTitle = 'Editor')
February 4, 2015 at 12:38 pm
#1775443