雪人奥特曼

摘要： --分组函数 select avg(emp.salary), max(emp.salary), count(emp.salary), count(emp.employeeid), count(*) from employee emp where emp.deptid = '10' --分组数据 部门的工资和 select emp.deptid, sum(emp.salary) ... 阅读全文