单项选择题
已知某MySQL 数据库中,有表及其字段如下:Employee(员工)表,字段:ID(标识,主键)、Name(姓名)、DepartmentID(班级标识,外键)Department(部门)表,字段:ID(标识,主键)、Name(名称)要查询各部门人数(包括空部门),可以使用的查询语句是()。
A.SELECT Department.Name,COUNT(Employee.ID)’班级人数’FROM Department RIGHT JOIN Employee WHERE Department.ID =Employee.DepartmentID GROUP BY Department.Name,Employee.DepartmentID
B.SELECT Department.Name,COUNT(Employee.ID)’班级人数’FROM Department RIGHT JOIN Employee ON Department.ID =Employee.DepartmentID GROUP BY Department.Name,Employee.DepartmentID
C.SELECT Department.Name,COUNT(Employee.ID)’班级人数’FROM Department LEFT JOIN Employee WHERE Department.ID =Employee.DepartmentID GROUP BY Department.Name,Employee.DepartmentID
D.SELECT Department.Name,COUNT(Employee.ID)’班级人数’FROM Department LEFT JOIN Employee ON Department.ID =Employee.DepartmentID GROUP BY Department.Name,Employee.DepartmentID
相关考题
-
单项选择题
已知某MySQL 数据库中,有表及其字段如下:Employee(员工)表,字段:ID(标识,主键)、Name(姓名)、DepartmentID(班级标识,外键)Department(部门)表,字段:ID(标识,主键)、Name(名称)要查询所有空部门,可以使用的查询语句是()。
A.SELECT。FROM Department LEFT JOIN Employee ON Department.ID =Employee.DepartmentID AND Employee.DepartmentID =NULL
B.SELECT。FROM Department LEFT JOIN Employee WHERE Department.ID =Employee.DepartmentID AND Employee.DepartmentID IS NULL
C.SELECT。FROM Department LEFT JOIN Employee ON Department.ID =Employee.DepartmentID WHERE Employee.DepartmentID IS NULL
D.SELECT。FROM Department LEFT JOIN Employee ON Department.ID =Employee.DepartmentID AND Employee.DepartmentID IS NULL -
单项选择题
在MySQL 中,JOIN 可用于()语句。
A.SELECT
B.DELETE
C.UPDATE
D.以上均可 -
单项选择题
在MySQL 中,下列不属于连接种类的是()。
A.左外连接
B.内连接
C.中间连接
D.交叉连接