单项选择题
在MySQL 中，查询姓名不是NULL 的语法正确的是（）。
A.WHERE NAME ＜＞NULL
B.WHERE NAME NOT IS NULL
C.WHERE NAME IS NOT NULL
D.WHERE NAME !=NULL
相关考题
-
单项选择题
已知某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.以上均可
