A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.

Name: A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.
Brand: Quizplus
Rating: 4.8 (30 reviews)

Question

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.​

Quizplus · Accepted Answer

A column alias defined in the SELECT clause can indeed be referenced in the ORDER BY clause of the same SELECT statement, allowing for sorting based on the alias.

A Column Alias That Has Been Defined in the SELECT