Questions Bank | Page 138867

An SQL statement to display the last name of the employees who is either a department manager or works on at least one project can be

None of these

select lname from employee, department where dno = dnumber union select lname from employee, works_on where essn = ssn

select lname from employee, department where mgr_ssn = ssn union select lname from employee, project

select lname from employee, department where mgr_ssn = ssn union select lname from employee, works_on where essn = ssn

View this question

Crowdly