试题详情
- 单项选择题 Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）
A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",
C、salary,
D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;
关注下方微信公众号，在线模考后查看
热门试题
- The EMPLOYEES table
- You need to perform
- Examine the stateme
- In which three cases
- Which are /SQL*Plus
- You need to produce
- The EMPLOYEE tables
- You need to create
- Examinethedescriptio
- Management has aske
- Which three statemen
- Which three SELECT s
- Which two are charac
- You need to calculat
- The EMP table conta
- Examine this stateme
- Examine the structu
- Which two are true a
- Examine the data in
- Which four are attri