select nir.inqtitleid,nii.itemcontent ,count(*) counts,round(RATIO_TO_REPORT(count(*)) over()*100,2)||'%' as percent
from news_inquiry_result nir,news_inquiry_item nii where nir.inqitemid=nii.id and nii.isdelete=1 and nir.inqtitleid=1
GROUP BY nir.inqtitleid,nir.inqitemid ,nii.itemcontent
[code="sql"]
select nir.inqtitleid,nii.itemcontent ,count(*) counts,round(count(*)/(select count(*) from news_inquiry_result a,news_inquiry_item b where a.inqitemid=b.id and b.isdelete=1 and a.inqtitleid=1
)*100,2)||'%' as percent
from news_inquiry_result nir,news_inquiry_item nii where nir.inqitemid=nii.id and nii.isdelete=1 and nir.inqtitleid=1
GROUP BY nir.inqtitleid,nir.inqitemid ,nii.itemcontent
[/code]
concat(round(count(*)*100,2),'%') as percent
RATIO_TO_REPORT 是什么?
这个不是oracle的函数
有必要在sql里面弄成百分比吗?在页面上格式化不行吗?一定要在这上面纠结?