dongyu1022 2011-09-19 15:42
浏览 220
已采纳

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

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

  • 写回答

4条回答 默认 最新

  • _1_1_7_ 2011-09-19 17:36
    关注

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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题？