关联子查询的组函数改写

botang

1. SELECT department_id, employee_id, salary
   
2. FROM EMPLOYEES e
   
3. WHERE 1 =
   
4. (SELECT COUNT(DISTINCT salary)
   
5. FROM EMPLOYEES
   
6. WHERE e.department_id = department_id
   
7. AND e.salary <= salary);
   
8. 
   
9. 
   
10. select a.department_id, e.employee_id , e.salary
    
11. from
    
12. (select  department_id, max(salary)  maxsal
    
13. from employees
    
14. group by department_id) a , employees e
    
15. where a.department_id =e.department_id
    
16. and a.maxsal=e.salary ;
    

复制代码