考试
2021-02-25 12:20:35

(多选题)Evaluate this SQL stateme

题目描述

Aremove the ORDER BY clause

Bremove the table alias prefix from the WHERE clause

Cremove the table alias from the SELECT clause

Dprefix the column in the USING clause with the table alias

Eprefix the column in the ORDER BY clause with the table alias

Freplace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

答案解析

[db:答案解析]

C,E

加载中...
AI正在思考中,请稍候...