oracle占比函数ratio_to_report
发布时间:2020-12-12 16:04:16 所属栏目:百科 来源:网络整理
导读:参考: http://www.jb51.cc/article/p-ejklnlfe-we.html SELECT "ROUND"([color=red]ratio_to_report(amount) over(),4)*100 AS ratio,VY.GKJBFROM (SELECT VX.GKJB,"SUM"(VX.AMOUNT) AS amount FROM(SELECT (CASEWHEN VI.GKJB '4' THEN '4'ELSEVI.GKJBEND) A
参考:
http://www.52php.cn/article/p-ejklnlfe-we.html
SELECT "ROUND"([color=red]ratio_to_report(amount) over(),4)*100 AS ratio,VY.GKJB FROM (SELECT VX.GKJB,"SUM"(VX.AMOUNT) AS amount FROM (SELECT (CASE WHEN VI.GKJB > '4' THEN '4' ELSE VI.GKJB END) AS GKJB,"SUM"(VI.N_MONEYTODAY) AS amount FROM VI_LIB_INVENTORY_DAILY vi WHERE "SUBSTR"(VI.S_ACCDATE,1,6) = '201606' AND VI.KJKMDM IN ('271','272') GROUP BY VI.GKJB ) vx GROUP BY VX.GKJB) vy (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |