下面是在 Oracle 中查询员工数大于 3 的部门最高、最低、平均工资的语句示例:
SELECT department, MAX(salary) as max_salary, MIN(salary) as min_salary, AVG(salary) as avg_salary
FROM employees
WHERE (SELECT COUNT(*) FROM employees e WHERE e.department = employees.department) > 3
GROUP BY department
这个语句会查询员工数大于 3 的部门的最高、最低、平