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. Zend 200-530 Exam Choose all that apply.

Question

Accepted Answer

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

Answer

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

Answer

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

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