DELETE
FROM     #banData
WHERE    EXISTS    (
         SELECT    BAN
         FROM    #banData b
        WHERE    b.BAN = #banData.BAN AND
            b.Row_ID < #banData.Row_ID
         )