Question

What is the need of “column Aliases” in “SELECT” clause?

(a) To assign a new label to the column in result set

(b) To overwrite the existing column name in result set

(c) To modify the column name while using literals, Expression, built_in functions with “SELECT clause

(d) All of the mentioned

I have been asked this question in semester exam.

I'd like to ask this question from The select Clauses in division Select Statement of MySQL

Answer 1

Right answer is (d) All of the mentioned

The best explanation: “Column Aliases” are used to assign a new label to the columns in the result set without actually changing the column name.