ORDER BY
clause. The ASC
and DESC
keywords can be added after the clause to specify the order of the sort.ORDER BY
clause 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 BY
clauses as shown in statement below.