Oracle group by函数：按照原权利人进行分组（如果原权利人为空，则取现权利人）

select sum(mj) SUM_MJ,
       QLRMC
  from (
            select a.mj,
                   decode(nvl(b.yxzmc,''),'',b.xzmc||b.cmc||b.zmc,b.yxzmc||b.ycmc||b.yzmc) as QLRMC
              from Ma_Tbdlmj a, ma_dk_qlr b    
             where a.dk_qlr_id = b.id
               and a.dk_id = '5ac47a65-edd8-4ee6-a0ae-a4ea3ad2a31a'
       )
group by QLRMC
order by QLRMC