Question: If , given the SQL statement SELECT EmpName FROM EMPLOYEE WHERE DeptID 7 OR DeptID > 1 2 then which of the following is true?
If given the SQL statement
SELECT EmpName
FROM EMPLOYEE
WHERE DeptID OR DeptID
then which of the following is true? Assume each employee can only have one department.
DeptIDs through are excluded from the results set, but DeptIDs through are included in the results set
all results are included in the results set
DeptIDs through are included from the results set, DeptIDs through are excluded in the results set, and all departments are included
no results are included in the results set
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
