Steve Rogers2,841 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 NIKOLAISEN53,478 Points
For descending order it is DESC with an e. So it would be:
ORDER BY SALARY DESC
Yves Bariuan4,300 Points
Try this code:
Select first_name, last_name FROM employees ORDER BY salary DESC