oracle开发笔记_0724

第一天上班,好苦逼,老大就丢了个sql给我自己看:

select nvl(sendunit,'合计') 苗源, 
 case when sendunit is not null and orgname is not null and  fadopt is null then '月份合计'
  when sendunit is   null   and  fadopt is null then '月份合计'
  else to_char(fadopt) end 月份,
 orgname crossfield,
-- sum(FADOPTqty) 进苗数,
 --sum(qcqty) 残次, 
-- sum(deadqty+ttqty) 本期死淘,
decode(  sum(FADOPTqty),0,'',  decode(round(( sum(deadqty+ttqty))/sum(FADOPTqty) ,3)*100,0,'', to_char( round(( sum(deadqty+ttqty))/