An SQL statement to display the first name and the last name of the employees who work on at least one project as well as those who do not work on any project can be

Question

Answer

select distinct fname, lname from employee right join works_on on essn = ssn

Answer

None of these

Answer

select distinct fname, lname from employee join works_on on essn = ssn

Answer

select distinct fname, lname from employee left join works_on on essn = ssn

Crowdly

An SQL statement to display the first name and the last name of the employees wh...

Want instant access to all verified answers on moovit.vit.ac.in?