cek data dobel

cek data dobel

SELECT COUNT(*) as repetitions, nik, nama
     FROM peta_set
      GROUP BY nik
     HAVING repetitions > 1;

CREATE TABLE tmp SELECT *
                 FROM peta_set 
                    GROUP BY (nik);