PL/SQL :: Basic Concepts - Discussion
Home > PL/SQL > Basic Concepts > MCQs Questions Discussion
58 / 41
Choose the correct option.
Evaluate this SQL statement:
SELECT employee_id, e.department_id, department_name, salary
FROM employees e, departments d
WHERE e.department_id = d.department_id;
Which SQL statement is equivalent to the above SQL statement?
ASELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
BSELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
CSELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department_id = d.department_id;
DSELECT employee_id, department_id, department_name, salary FROM employees JOIN departments USING (e.department_id, department_i;
Answer: Option (Login/Signup)
Show Explanation
Asked In ::
No Discussion on this question yet!