2. Some simple SQL Select statements: Step 11

Demo

Ordering in Descending order

The output can be sorted in descending order by using the DESC qualifier. For example, to show the name and salary in alphabetical with the highest salaried employee first:

SQL

SELECT ename FROM emp ORDER BY sal DESC;

Output

ename
KING
SCOTT
FORD
JONES
BLAKE
CLARK
ALLEN
TURNER
MILLER
MARTIN
WARD
ADAMS
JAMES
SMITH

Progress

Proceed to Next step