题目内容

The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）

A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.

查看答案

搜索结果不匹配？点我反馈

更多问题

纳税人提供建筑业劳务（不含装饰劳务）的，其营业额应当包括工程所用原材料、设备及其他物资和动力价款在内。（）

A. 正确
B. 错误

用你自己教学的例子，谈谈你是如何指导学生掌握语文学习方法的。

结核杆菌涂片，用萋尼氏法进行抗酸性染色，镜检可见结核菌呈（）。

与企业传统的薪资结构相比，宽带型薪资结构具有哪些特征和作用？