试题详情
- 单项选择题 Examine the description of the EMPLOYEES table:
Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the 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 SQL sta
- Which two statements
- Which three statemen
- ClicktheExhibitbutto
- Which are DML statem
- What is true of usin
- Which three SELECT s
- Evaluate these two S
- The STUDENT_GRADES
- You need to design
- Which one is a syste
- The CUSTOMERS table
- You need to create
- A SELECT statement
- For which two constr
- What is true regardi
- You need to modify t
- Which two statements
- Which is an iSQL*Plu
- Which four statement