select sum(sal),deptno from tt group by deptno;select sum(sal) over(partion by deptno),deptno from tt;select sum(sal),deptno from (select distinct sal,deptno from tt) group by deptno;select distinct sum(sal) over(partion by deptno),deptno ...
显示全部select sum(sal),deptno from tt group by deptno;
select sum(sal) over(partion by deptno),deptno from tt;
select sum(sal),deptno from (select distinct sal,deptno from tt) group by deptno;
select distinct sum(sal) over(partion by deptno),deptno from tt;
select count(distinct sal),deptno from tt group by deptno;
select sum(distinct sal),deptno from tt group by deptno;
收起