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' GROUP BY ta.had_submit, t