我想求出来一个数字的占总数的百分比,可是我求出来的确是个整数,没有精确到小数点后两位,大家看看是怎麽回事,在线等的你们的回答~~~~~~~
select num,allnum,round(num/k.allnum,2)rate
from dual ,(select sun(sum)allnum from dual)k;
select num,allnum,round(num/k.allnum,2)rate
from dual ,(select sun(sum)allnum from dual)k;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货