Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- b.nama_bidang,
- COUNT(*) AS JML,
- SUM(IF(k.kd_gol = 1, 1, 0)) AS jml_satu,
- SUM(IF(k.kd_gol = 2, 1, 0)) AS jml_dua,
- SUM(IF(k.kd_gol = 3, 1, 0)) AS jml_tiga
- FROM karyawan k
- LEFT JOIN bidang b ON b.kd_bidang = k.kd_bidang
- GROUP BY k.kd_bidang
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement