Q&A for those using, extending or developing Emacs
declare @YourTable table (Pk int, FkIdResult int, FkIdSimul int) insert @YourTable values (1,43,1244) insert @YourTable values (2,43,1244) insert @YourTable values (3,52,1244) insert @YourTable values (4,52,1244) DELETE tbl from ( select row_number() over (partition by FkIdResult, FkIdSimul order by Pk desc) as rn , * from @YourTable ) tbl where rn > 1 select * from @YourTable