sql横向求占比 sql求平均

SELECT C1/C C1B, C2/C C2B, C3/C C3B, C4/C C4BFROM (SELECT SUM(CASE WHEN fFactMoney=300 AND fFactMoney=500 AND fFactMoney=800 THEN 1 ELSE .

oracle查询 select (select count(1) from jiaoshibiao where gongzi >=2000 and gongzi<=5000) / (select count(1) from jiaoshibiao) * 100 || '%' as 比例 from dual

很简单:select rate*100||'%' from rate_tab 就是先乘以100,再加百分号.

假如你的数据列名为:a,b,c,d,e,f,g 那么你横向汇总的SQL语句是: select a,b,c,d,e,f,g,a+b+c+d+e+f+g from 表名 那么你纵向汇总的SQL语句是: select sum(a),sum(b),sum(c),sum(d),sum(e),sum(f),sum(g) from 表名 求所有数据总和的SQL语句是:select sum(a)+sum(b)+sum(c)+sum(d)+sum(e)+sum(f)+sum(g) from 表名

select t.`id` as id ,(select SUM(t1.`id`) from table t1 where t1.`id` = t.`id`) as 数量,(select SUM(t1.`id`) from table t1 where t1.`id` = t.`id`)/(select COUNT(*) from table ) as 占比 from table as t GROUP BY t.`id`

写法如下:SUM(p.payable - p.single_price) AS profitCount,m.order_id AS orderId,m.create_time,m.dept_airport_code,m.arrv_airport_code,m.payable AS priceFROMom_.

如果你连接的库为Oracle可以偿试如一条语句完成查询,否则是一条SQL语句不能完成的.SELECT 部门,岗位工资,技能工资,岗位工资+技能工资 应付工资 FROM 表名union allselect '合计',sum(岗位工资),sum(技能工资),sum(岗位工资+技能工资) from 表名

WITH tb AS( SELECT '01' AS classift_code ,2315.92 AS classify_incomeUNION ALLSELECT '03',3UNION ALLSELECT '04',838UNION ALLSELECT '06',2.4UNION ALLSELECT '15',75.2)SELECT *,classify_income/SUM(classify_income) OVER() AS 比例 FROM tb

标准答案:declare @ACount int select @ACount=count(*) from 表 --计算总数,避免放在大数据的select中影响效率 if @ACount>0 --判断是否有记录,无记录时@Acount为.

我记得有个函数 ,不过有点忘了 可以这样嘛,select round(1/6*100,2) || '%' from dual; select round(number1 / number2 * 100 , 2) || '%' from table_name;