oracle中的group by

oracle中的group by

1.创建一张测试数据表

create table Test(empid number,
                    depid  number,
                    salenum number
                   );

insert into Test(empid, depid, salenum) values(1000, 10000, 100);

insert into Test(empid, depid, salenum) values(1001, 10000, 200);

insert into Test(empid, depid, salenum) values(1002, 10001, 200);

insert into Test(empid, depid, salenum) values(1003, 10002, 500);

insert into Test(empid, depid, salenum)values(1004, 10000, 300);

 

//要获取相同部门的所有员工的销售总额

select  sum(salenum)  from Test group by depid;

SQL> select  sum(salenum)  from Test group by depid;

SUM(SALENUM)
------------
         600
         500
         200