select column_1,sum(column_2) as sum_col from tb_name group by column_1; 呵呵 这就不止一条了
--根据实际情况,实际用 select sum(col) from tb select col1,sum(col2) from tb group by col1select col1,name,sum(col2) over(partition by col1) from tb --楼主想统计什么 贴出来啥
sum()的用法还比较多,可简单可复杂
sum() 很基础,可用的很多
最基础的 select sum(column_name) as sum_col from tb_name;
select deptno 部门号,count(*) 人数,sum(sal) 部门总工资 from emp group by deptno; 部门号 人数 部门总工资 ---------- ---------- ---------- 30 6 9400 20 3 6775 10 3 9625
from tb_name;
from tb_name
group by
column_1;
呵呵 这就不止一条了
--根据实际情况,实际用
select sum(col) from tb
select col1,sum(col2) from tb group by col1select col1,name,sum(col2) over(partition by col1) from tb
--楼主想统计什么 贴出来啥
from emp
group by deptno;
部门号 人数 部门总工资
---------- ---------- ----------
30 6 9400
20 3 6775
10 3 9625