Zend Preparation | PHP Quiz (Learning Mode)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75

A table named employees is given below:

empid	fname	lname	deptid	rating	salary
100	James	Johnson	50	2	85000.00
200	Barry	Levinson	70	3	66000.00
300	Linda	Smith	90	1	77000.00
400	Larry	David	55	2	82000.00
500	Sandy	Jones	65	3	78000.00
600	Julia	Martinez	85	2	88000.00

Which of the following statements would return the employees' names, in ascending order, based on their last name and first name?

select fname, lname from employees order by lname;

select fname, lname from employees order by lname asc;

select fname, lname from employees order by lname desc;

select fname, lname from employees group by lname;