Articles Comments

{ Berbagi, Menulis, Dan Mengajar } Ilmu… » 7. Operating System » Query Menghitung Jumlah Data Yang Sama

Query Menghitung Jumlah Data Yang Sama

January 22nd, 2020 | Add a Comment

SELECT no_wp,
COUNT(*) AS c
FROM npwpd
GROUP BY no_wp
HAVING c > 1
ORDER BY c DESC

Written by

Filed under: 7. Operating System

Leave a Reply

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>