An SQL statement to display the first name of the employees who is a department manager and has no dependent registered in the company database can be

Question

Answer

None of these

Answer

select fname from employee, department where mgr_ssn=ssn and where not exists (select * from dependent where essn = ssn)

Answer

select fname from employee, department where dno=dnumber and not exists (select * from dependent where essn = ssn)

Answer

select fname from employee, department where mgr_ssn=ssn and not exists (select * from dependent where essn = ssn)

Crowdly

An SQL statement to display the first name of the employees who is a department ...

Хочете миттєвий доступ до всіх перевірених відповідей на moovit.vit.ac.in?