/*

Delete rows that have a duplicate pathhash value and are older than the newest ID (ID column is ascending INT)

*/

;with DuplicateCandidateRows

as

(

select Id, row_number() over (partition by pathhash order by...