New Free Workshop on RBI Grade B Descriptive Answer Writing - Join Us!
Register

Question

SELECT E.EmpFname, E.EmpLname, P.EmpPosition FROM EmployeeInfo E INNER JOIN EmployeePosition P ON E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager');

This query will give

A fetch all employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
B fetch all employees who also does not hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
C fetch all employees who also hold the managerial position from outer join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
D fetch Top employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
E None Correct Answer Incorrect Answer

Solution

The correct answer is A

Practice Next
×
×