Get Off-Campus Placement Jobs Info !!!
Programs asked in Mettl Coding Round
Click To Practce List of Programs asked in Nagarro !!!

Virtusa Written Test Qs.(PL/SQL) :: Basic Concepts - Discussion

57 / 119

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 :: Virtusa

Post Your Answer Here:     

No Discussion on this question yet!