DML-select-Order by:

nThe order by clause is used to sort and order the data in a result dataset by the values contained in the columns

Syntax:

SELECT column_name(s)
FROM table_name  ORDER BY column_name(s) ASC|DESC

 Query:

SELECT * FROM Emptbl1
ORDER BY Empname DESC/ASC