G

Gopal Sharma • 38.32K Points
Coach

Q. 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
  • Correct Answer - Option(D)
  • Views: 25
  • Filed under category MySQL
Explanation by: Gopal Sharma
Imagine you have a table called "products" with columns like "product_id", "product_name", and "price". You want to display the price of each product, but you want to call it "cost" in your results instead of "price".

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Question analytics