Try!
selectmingcheng,
max(decode(danwei, '箱', guige, null))guige,
max(decode(danwei, '箱', danwei, null)) danwei,
sum(decode(danwei, '箱', xishu, 0))xishu,
(sum(decode(danwei, '瓶', yongliang, 0)) / sum(decode(danwei, '箱', xishu, 0))) + sum(decode(danwei, '箱', yongliang, 0)) yongliang
from t
group by mingcheng;
|