Databases SQL Reporting by Example Orientation: Selecting Data Orientation Quiz

Steve Rogers
Steve Rogers
2,282 Points

The quiz asked me to return a list of employees ordered by salary starting with the highest. I got it wrong?

I entered

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?

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 50,936 Points

For descending order it is DESC with an e. So it would be:

ORDER BY SALARY DESC
Yves Bariuan
Yves Bariuan
4,183 Points

Try this code:

Select first_name, last_name FROM employees ORDER BY salary DESC