-- try
update yourTable
   set qty = 0
 where id in (select id
                from (select t.*,
                             row_number() over(partition by name, qty order by id) rn
                        from yourTable t)
               where rn <> 1)

------解决方案--------------------
SQL code
-- TRY IT ..
UPDATE TT T1
   SET QTY = 0
 WHERE EXISTS (SELECT 1
          FROM TT T2
         WHERE T1.NAME = T2.NAME
           AND T1.ID > T2.ID);