0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created sep 28 22 anonymous