An SQL statement to display the name of the dependents and the first name and the last name of the employees the dependents are associated with in alphabetic order of the name of the dependents can be

Question

Answer

select dependent_name, fname, lname from employee, dependent where essn = ssn order by dependent_name

Answer

select dependent_name, fname, lname from employee, dependent order by dependent_name

Answer

None of these

Answer

select dependent_name, fname, lname from employee join dependent where essn = ssn order by dependent_name

Crowdly

An SQL statement to display the name of the dependents and the first name and th...

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