3.4 AS ने परिणाम कॉलमला नवीन नाव द्या

By Ravindra Bagale Last updated: 31 October 2026

का (Why). Manager slides मध्ये कच्चे कॉलम नावे वाईट दिसतात.

काय (What). AS निकालामध्ये कॉलमला तात्पुरते नाव देतो (alias).

कसं (How). SELECT amount_inr AS sales_inr FROM orders;

पायऱ्या

उदाहरण 1 · dataset: raja_coffee

SELECT city AS store_city, amount_inr AS sales_inr
FROM orders
LIMIT 4;

Output

Meaning. हेडर्स आता store_city आणि sales_inr दाखवतात.

Ravindra Bagale's Tip

Alias names cannot have spaces unless you quote them — prefer sales_inr style.