Multiple choice technology databases

Sorting SQL statement result data by column alias is not possible.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL allows ordering by column aliases defined in the SELECT list, because the alias is resolved after the SELECT clause but before ORDER BY is processed. Hence sorting by an alias is possible, making the claim that it isn’t possible false.