Which of the following statements is an example of a SELF JOIN?
A) SELECT department_id, department_name,location_id, city FROM departments NATURAL JOIN locations;
B) SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id);
C) SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id) AND e.manager_id = 149 ;
D) SELECT worker.last_name emp, manager.last_name mgr FROM employees worker JOIN employees manager ON (worker.manager_id = manager.employee_id);
D) SELECT worker.last_name emp, manager.last_name mgr FROM employees worker JOIN employees manager ON (worker.manager_id = manager.employee_id);
You might also like to view...
A ____ is an attempt to convince someone about the merits of a particular product or service, or to expose them to something in a positive way that they will remember.
A. commercial advertisement B. documentary C. slice-of-life vignette D. comedy sketch
____ are small programs that take care of software-specific problems, or bugs, such as security holes.
A. Backups B. Applets C. Scripts D. Patches