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 ORDER BY can absolutely sort by column aliases. You can assign an alias in the SELECT clause and then use that alias in ORDER BY. For example, 'SELECT salary*12 AS annual_sal FROM emp ORDER BY annual_sal' works perfectly.