candy 发表于 2018-10-22 09:57:20

oralce sql练习

SELECT last_name, first_name, department_id, salary　　
FROM employees
　　
WHERE (department_id, salary) IN
　　
       (SELECT department_id, MAX(salary)
　　
          FROM employees
　　
         GROUP BY department_id)
　　
ORDER BY department_id;


页: [1]
查看完整版本: oralce sql练习