oracle百分比查询怎么改写成mysql语句？

Question

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

Answer 1

[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]