ماڈیول 2 · سبق 3 از 4کورس میں 7/57~6 min

ماڈیول اسباق (3/4)

AS کے ساتھ نام تبدیل کرنا

By default, columns in the result have the same name as the source column. When you select an expression (a calculation, a concatenation, an aggregate) the default name may look ugly or unclear. With AS you assign an alias, that is, a name of your choice:

SQL

SELECT <colonna_o_espressione> AS <alias>
FROM   <tabella>;

The keyword AS is optional (salary salary_eur works too), but writing it makes the query more readable. If the alias contains spaces or significant uppercase letters, wrap it in double quotes: AS "Annual Salary".

Examples

SQL

-- Rinomina semplice (in inglese per convenzione):
SELECT first_name AS name,
       last_name  AS surname
FROM employees;

-- Alias su un'espressione calcolata:
SELECT first_name,
       last_name,
       salary * 13 AS annual_pay
FROM employees;

Try it

ورزش#sql.m2.l3.e1

کوششیں: 0لوڈ ہو رہا ہے…

Extract each employee's last name and salary, renaming the columns to 'last' and 'salary_eur'.

ایڈیٹر لوڈ ہو رہا ہے…

اشارہ دکھائیں۔

The keyword is AS: SELECT column AS new_name.

3 کوششوں کے بعد حل دستیاب ہے۔

Review exercise

ورزش#sql.m2.l3.e2