A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'pnmandailingnata_n1484907_sipp.dataumumweb.tglPendaftaran' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT YEAR(tglPendaftaran) as tahun FROM dataumumweb ORDER BY tglPendaftaran DESC

Filename: /home/pnmandailingnata/public_html/sipp/models/perkara/statistik_m.php

Line Number: 23