Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? ()
- A、remove the ORDER BY clause
- B、remove the table alias prefix from the WHERE clause
- C、remove the table alias from the SELECT clause
- D、prefix the column in the USING clause with the table alias
- E、prefix the column in the ORDER BY clause with the table alias
- F、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"
正确答案:C
答案解析:有
微信扫一扫手机做题