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

You CAN sort SQL results by column alias - this is a standard SQL feature. The ORDER BY clause can reference column aliases defined in the SELECT list, even though the alias doesn't exist in the original table. This is because ORDER BY is logically processed after SELECT, so the aliases are available. The statement claims sorting by alias is not possible, which is false.

Keep practicing — related questions