1.Give a query for a list of each department(number and name)with their number of employees.这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/01 22:14:19
![1.Give a query for a list of each department(number and name)with their number of employees.这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.](/uploads/image/z/14871043-19-3.jpg?t=1.Give+a+query+for+a+list+of+each+department%28number+and+name%29with+their+number+of+employees.%E8%BF%99%E6%98%AFEMP%E8%A1%A8%E7%9A%84%E9%97%AE%E9%A2%98%2C2.give+a+query+for+a+list+of+each+department%28number+and+name%29+for+all+department+with+no+employees.)
1.Give a query for a list of each department(number and name)with their number of employees.这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.
1.Give a query for a list of each department(number and name)with their number of employees.
这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.
1.Give a query for a list of each department(number and name)with their number of employees.这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.
select dep.dept_no,dep.name,count(emp.empno) employeeNumber
from ps_department dep,ps_employee emp
where dep.dept_no = emp.dept_no
and dep.current_status = 'Y' /* in use */
and emp.current_status = 'Y' /* in use */
fyi.
为每个部门员工的编号和名称做一份调查列表。