试题详情
- 单项选择题 Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary
B、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
C、SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
D、You cannot find the information because there is no common column between the two tables.
关注下方微信公众号，在线模考后查看
热门试题
- Examine the data in
- What are two reasons
- You need to perform
- A subquery can be us
- You own a table cal
- Examine the descrip
- You need to change t
- ClicktheExhibitbutto
- Which three are DATE
- You created a view
- Which SQL statement
- You need to display
- Which two statements
- The STUDENT_GRADES
- Youneedtoproducearep
- You need to modify t
- Examine the descrip
- In a SELECT statemen
- When should you crea
- Which best describes