试题详情
- 单项选择题 Click the Exhibit button and examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
A、The SELECT statement is syntactically accurate.
B、The SELECT statement does not work because there is no HAVING clause.
C、The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D、The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
关注下方微信公众号，在线模考后查看
热门试题
- You are the DBA for
- Evaluate the SQL sta
- Top N analysis requi
- You need to design
- Evaluate the set of
- You need to create a
- Which SQL statement
- Which clause should
- ClicktheExhibitbutto
- Examine this stateme
- A subquery can be us
- The DBA issues this
- You need to give th
- Which SELECT stateme
- You would like to di
- Which two statements
- Which two are charac
- TheEMPtablecontainst
- The EMPLOYEES table
- Examine the descrip