SELECT * FROM (
SELECT
${IF(type=1," 年 name,","")}
${IF(type=2," 月 name,","")}
${IF(type=3," 日 name,","")}
SUM(a.value)/10000 value
FROM table a
GROUP BY
${IF(type=1,"年","")}
${IF(type=2,"月","")}
${IF(type=3,"日","")}
这样自己替换一下看看