Question

oracle中像使用sum函数对某一列数据进行求和，但是同时需要输出其他字段，怎么求到总数

select ta.had_submit hadsubmit,
ta.rpt_channel_id,
sum(ta.had_submit),
d.dict_value dictvalue
from t_stat_timeinterval_area ta join t_am_dict d on d.dict_code=ta.rpt_channel_id and d.dict_type='casesource'

Answer 1

SELECT
ta.had_submit hadsubmit,
ta.rpt_channel_id,
SUM (ta.had_submit),
d.dict_value dictvalue
FROM
t_stat_timeinterval_area ta
JOIN t_am_dict d ON d.dict_code = ta.rpt_channel_id
AND d.dict_type = 'casesource'
GROUP BY
ta.had_submit,
ta.rpt_channel_id,
d.dict_value;
这样写试一下，看看是否好用。