试题详情
- 单项选择题 Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）
A、SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B、SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
C、SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
E、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
关注下方微信公众号，在线模考后查看
热门试题
- Examine the structu
- Evaluate the SQL sta
- You need to perform
- Scott issues the SQ
- The STUDENT_GRADES
- Which two tasks can
- A SELECT statement
- You need to create
- The EMPLOYEES table
- You need to change t
- Which is an /SQL*Plu
- Examinethedescriptio
- Examine these state
- The CUSTOMERS table
- Which three are DATE
- You need to create a
- Which four statement
- The database adminis
- You need to display
- What are two reasons