Select Duplicate Value

 SELECT 

    `kode`, 

    COUNT(`kode`)

FROM

    `table_name`

GROUP BY `kode`

HAVING COUNT(`kode`) > 1

 INSERT INTO `tb_barang_cabang_1`(SELECT * FROM tb_barang WHERE kode_barcode IN (SELECT DISTINCT kode_barcode FROM tb_barang_temp WHERE cabang_owner='1'))

 UPDATE `tb_barang_temp` SET `tipe_jual`='',`gambar`='',`gambar2`='',`gambar3`='',`tipe_iklan`=''