比如:一个字段affirmdate为date类型,有年月日,但我需要按年月分组,怎么分组呢?表TTname data affirmdate
aaa 20 2008-08-02 aaa 20 2008-08-24bbb 30 2008-09-02bbb 10 2008-09-01aaa 30 2008-09-03ccc 5 2008-01 -03结果为name data affirmdateaaa 40 2008-08aaa 30 2008-09bbb 40 2008-09ccc 5 2008-01如何分组呢
请教了
aaa 20 2008-08-02 aaa 20 2008-08-24bbb 30 2008-09-02bbb 10 2008-09-01aaa 30 2008-09-03ccc 5 2008-01 -03结果为name data affirmdateaaa 40 2008-08aaa 30 2008-09bbb 40 2008-09ccc 5 2008-01如何分组呢
请教了
group by name, to_string(affirmdate,'yyyy-mm');
elect name, sum(data) data, to_char(affirmdate,'yyyy-mm') affirmdate
group by name, to_string(affirmdate,'yyyy-mm');
substr(to_char(t.affirmdate,'yyyy-mm-dd'),1,10)
from t
group by substr(to_char(t.affirmdate,'yyyy-mm-dd'),1,10),name