ORDER BY Keyword

The keyword can be use to sort the result in ASC/DESC order. By Default the result is populated in ascending order.

Select * From EMP_DATABASE  ORDER BY EMP_NAME;

Select * From EMP_DATABASE ORDER BY EMP_NAME DESC;

Select * From EMP_DATABASE ORDER BY EMP_NAME ASC, EMP_ID DESC