试题详情
- 单项选择题 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, 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.
- A
关注下方微信公众号，在线模考后查看
热门试题
- You issued the foll
- What is tr
- Examine the descrip
- Your database&
- RMAN offers
- Which three statemen
- Identify three featu
- You have
- You have
- Given： What is
- 下面哪个操作会导致用户连接到ORACLE
- Click the
- A company has a bus
- Given that&ensp
- Which statement is t
- Which two statements
- In a SELECT statemen
- You work
- Which taskQ
- In your p