对于缺少的月份，您可以对所有月份进行联合查询，并与表联接
SELECt t1.`year`,t.`month`,coalesce(t1.payment,0) paymentFROM(SELECT 1 AS `month`UNIOn SELECT 2 AS `month`UNIOn ....SELECT 12 AS `month`) AS tLEFT JOIN your_table t1 on(t.`month` = t1.`month`)WHERe ....
对于缺少的月份，您可以对所有月份进行联合查询，并与表联接
SELECt t1.`year`,t.`month`,coalesce(t1.payment,0) paymentFROM(SELECT 1 AS `month`UNIOn SELECT 2 AS `month`UNIOn ....SELECT 12 AS `month`) AS tLEFT JOIN your_table t1 on(t.`month` = t1.`month`)WHERe ....
Fiddle Demo
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
