一个员工表,employees和一个部门表,departments;
员工表有员工编号employee_id,员工姓名employee_name,员工工资salary和部门编码department_id;
部门表有部门编号department_id,部门名称department_name;
部题描述:查出各部门的员工工资大于3000和小等于3000的人数。
- select d.department_id,
- sum(decode(sign(e.salary - 3000),1,1,-1,0)) maxSal,
- sum(decode(sign(3000 - e.salary),1,1,-1,0)) minSal
- from employees e, departments d
- where e.department_id = d.department_id
- group by d.department_id;
红色的是不是写的有问题
//--------------sign()函数根据表达式的值是0、正数还是负数,分别返回0、1、-1;