Command to check duplicate entries in mysql

SELECT DISTINCT(cource_code) AS cource, COUNT(cource_code) AS Count FROM kursus_psmb GROUP BY cource_code HAVING Count > 1