<<< Previous question <<< Question ID#0244.md >>> Next question >>>
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?
- A) select fname, lname from employees order by lname;
- B) select fname, lname from employees order by lname asc;
- C) select fname, lname from employees order by lname desc;
- D) select fname, lname from employees group by lname;
Answer
Answer: A, B