Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?()
A. SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
B. SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
C. SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
D. SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id )
查看答案
按照安装地点划分,下列()与其他三项不属于同一类别。
A. GW7-252
B. GW5-126
C. GN19-10
D. GW4-126
在我国实行财政补贴政策的目的在于提高居民收入水平。()
A. 正确
B. 错误