oracle id重复的数据合并,下面sql 语句 怎么用group by将相同的数据合并？

select B.EQ_IMPORTANTPARTLCMID, D.SORT_NAME,

c.equipment_name,

A.KEYSPARENAME ,

decode(A.ENGINELECTRICSORTCODE,'1','机械','2','电气','3','其他')ENGINELECTRICSORTCODE,

A.LIFECYCLE,

C.site_code, E.zcs,RWWCL,

E.YWC,E.WWC,E.YYH,WYH,WJCYH,

decode( A.taskexecstatus,'0','未完成','1','已完成') as taskexecstatus

from T_EQ_IMPORTANTPARTLCM A

left join T_EQ_IMPORTANTPARTLCMTASK B on A.EQ_IMPORTANTPARTLCMID=b.eq_importantpartlcmid

left join T_EQ_BA_EQUIPMENT C on A.eq_ba_equipment_id=C.t_eq_ba_equipment_id

left join T_EQ_BA_EQUIPMENT_SORT D on D.t_eq_ba_equipment_sort_id=C.section_id

left join (select t.eq_importantpartlcmid ,

count(t.eq_importantpartlcmid) zcs,

round((count(t.CHECKTIME)/count(t.eq_importantpartlcmid))*100,2) RWWCL,

count(t.CHECKTIME)