delete b.*
from tbl a
inner join tbl b
on a.col1 = b.col1