A table named employees is given below: Which of the following statements would return the employees names , in ascending order, based on their last name and first name? Each correct answer represents a complete solution . Choose all that apply.

Question

Accepted Answer

A. select fname, lname from employees order by lname; D. select fname, lname from employees order by lname asc;

Answer

B. select fname, lname from employees order by lname desc;

Answer

C. select fname, lname from employees group by lname;

A table named employees is given below: Which of the following statements would return the employees names , in ascending order, based on their last name and first name? Each correct answer…

Question

Exhibit

Options

How the community answered

Community Discussion