Friday, December 9, 2022

Select Duplicate Value

 SELECT 

    `kode`, 

    COUNT(`kode`)

FROM

    `table_name`

GROUP BY `kode`

HAVING COUNT(`kode`) > 1

No comments:

Post a Comment