mysql 指定日期条件求和_如何在mysql中按每个日期对字段进行求和-问答-阿里云开发者社区-阿里云...

我正在尝试根据案件的日期查询QUERY总计字段罚款，何时但不成功，有解决方案吗？

我的桌子

NIP NAMA TANGGAL JENIS_KEHADIRAN DENDA

10016 Novi Irawati 2020-01-03 sakit 37500

10016 Novi Irawati 2019-12-19 ijin 50000

10016 Novi Irawati 2019-12-19 ijin 50000

10010 Muhammad Hayyi 2019-12-15 hadir 0

10011 Rifyal Ainul Yaqin 2019-12-16 hadir 0

10012 Misbahul Munir 2019-12-20 hadir 0

10013 Ari Arif Sholeh 2019-12-20 hadir 0

10014 Sopantoni Hendri C 2019-12-20 hadir 0

10015 Alfan 2019-12-20 hadir 0

10017 Romiatul Jamil 2019-12-20 hadir 0

10018 Fidatul Hasanah 2019-12-20 hadir 0

10019 Abdul Muik 2019-12-20 hadir 0

我的查询

select nip,nama,case

when month(tanggal) = month(tanggal) then sum(denda)

end as total_denda

from potongan_absen

group by nip

表I求和后

NIP NAMA TANGGAL JENIS_KEHADIRAN DENDA

10016 Novi Irawati 2020-01-03 sakit 37500

10016 Novi Irawati 2019-12-19 ijin 100000

10010 Muhammad Hayyi 2019-12-15 hadir 0

10011 Rifyal Ainul Yaqin 2019-12-16 hadir 0

10012 Misbahul Munir 2019-12-20 hadir 0

10013 Ari Arif Sholeh 2019-12-20 hadir 0

10014 Sopantoni Hendri C 2019-12-20 hadir 0

10015 Alfan 2019-12-20 hadir 0

10017 Romiatul Jamil 2019-12-20 hadir 0

10018 Fidatul Hasanah 2019-12-20 hadir 0

10019 Abdul Muik 2019-12-20 hadir 0