Which result set will be obtained from this joinSELECT - ProProfs Discuss
Topics
Products
Follow Us:

Which result set will be obtained from this joinSELECT d.department_name, s.first_name, s.last_name, s.title, s.salary FROM employee s, department dWHERE s.salary > 20000 AND s.title = ANALYST AND ( d.department = FINANCE OR d. department = SALES )?



A. This SQL will list all employees in the Finance department earning more than 20000
B. This SQL will list all employees who are in the Finance or Sales department earning more than 20000
C. This SQL will list all employees who are Analysts in the Finance or Sales department earning more than 20000
D. This SQL will return a cartesian product
E. None of the above

This question is part of EASY ORACLE PLSQL QUIZ
Asked by Ibecruzin, Last updated: Dec 18, 2019

+ Answer
Request

2 Answers

John Adney

Why ?? I am not getting it.
 

John Smith

John Smith

Answered Nov 04, 2016

This SQL will return a cartesian product
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.