sql - SQL SERVER中的select查询需要支持
问题描述
我有3张这样的桌子:
- Employee_Table (Employee_Number, Employee_Name, Department_Number)
With Employee_Number is PRIMARY KEY, Department_Number is FOREIGN KEY;
- Employee_Skill_Table (Employee_Number, Skill_Code, Date Registered)
With PRIMARY KEY (Employee_Number, Skill_Code);
- Department (Department_Number, Department_Name)
With PRIMARY KEY (Department_Number);
我该如何指定
the departments which have >= 3 employees
帮我!
解决方案
如果您只需要人数超过 3 人的部门,请尝试此查询
SELECT d.Department_Name
FROM Department d
JOIN Employee_Table e ON e.Department_Number = d.Department_Number
GROUP BY Department_Name
HAVING COUNT(*) >= 3
推荐阅读
- python - TensorFlow 导入错误,无法从部分初始化模块导入模块 pywrap_tensorflow
- python - 自定义 Django url 路径转换器(逗号分隔的整数)
- javascript - Jquery append 不适用于动态显示
- android - Pub/Sub - 当注册时状态为 ACTIVE 时推送到 API
- node.js - 编译后无法覆盖 OJLINTTASKCOLLECTION 模型,同时使用 mongoose 在 nodejs 中创建多个“小鹿”实例
- c++ - 如何删除类的实例?
- git - HTTP ERROR 403 请求 bitbucket 中没有包含有效的 crumb
- html - form.disable() 没有禁用表单内的按钮
- hibernate - spring data jpa使用线程执行器访问存储库不读取更新的对象
- r - 系数不可估计 voom r