Steve Rogers2,282 Points
The quiz asked me to return a list of employees ordered by salary starting with the highest. I got it wrong?
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES ORDER BY salary DSC;
and several other variations but I coudln't get it to work. Any ideas?
KRIS NIKOLAISENPro Student 50,936 Points
For descending order it is DESC with an e. So it would be:
ORDER BY SALARY DESC
Yves Bariuan4,183 Points
Try this code:
Select first_name, last_name FROM employees ORDER BY salary DESC