Beranda › Tanpa Kategori

mysql check duplicate rows, How To Find Duplicate Values in MySQL

Kamis, 22 April 2021 Tambah Komentar Edit

SELECT 
    col, 
    COUNT(col)
FROM
    table_name
GROUP BY col
HAVING COUNT(col) > 1;

Belum ada Komentar untuk "mysql check duplicate rows, How To Find Duplicate Values in MySQL"

Posting Komentar

Langganan: Posting Komentar (Atom)