试题详情
- 单项选择题 Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables. 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 JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B、SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C、SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (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 structu
- Examinethestructureo
- Examine the structu
- For which action can
- Which are DML statem
- What is true about u
- Which three are true
- Which is an iSQL*Plu
- User Mary has a view
- Which two statements
- In which scenario wo
- TheEMPLOYEEStablecon
- Evaluate the SQL st
- Which are DML statem
- Which object privile
- Which three statemen
- ExaminethedataoftheE
- You need to create a
- When should you crea
- You define a multipl