📊 MySQL
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
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Explanation: 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".

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".

💬 Discussion

📊 Question Analytics

👁️
100
Total Visits
📽️
12 mo ago
Published
🎖️
Gopal Sharma
Publisher
📈
85%
Success Rate