ORDER BYclause. The
DESCkeywords can be added after the clause to specify the order of the sort.
ORDER BYclause then the result can be obtained without executing any sorting. We therefore for performance reasons strongly recommend that necessary indexes are declared when using
ORDER BYclauses as shown in statement below.