色婷婷狠狠18禁久久YY,CHINESE性内射高清国产,国产女人18毛片水真多1,国产AV在线观看

oracle中如何求百分比

錢浩然2年前14瀏覽0評論

oracle中如何求百分比?

select a.wh,a.age,a.count1,round((a.count1/b.count2),2)*100||'%'from(select wh ,avg(age) age , count(wh) count1 from employee group by wh) a,(select count(*) count2 from employee) b這樣試試