In SQL, which concept allows you to assign a temporary name to a column or expression in a query?

In SQL, which concept allows you to assign a temporary name to a column or expression in a query?

• A. Label
• B. Alias
• C. As Name
• D. SQL Alias

Answer: (D)

Giving a temporary name to a column or expression in a query is called an alias. It makes derived values easy to read and lets you refer to them in other parts of the query, like ORDER BY or GROUP BY. You usually write it with AS, such as SELECT salary * 12 AS annual_salary FROM employees, though AS is optional in many systems. The alias exists only for the duration of that query and does not change the actual table schema.

Giving a temporary name to a column or expression in a query is called an alias. It makes derived values easy to read and lets you refer to them in other parts of the query, like ORDER BY or GROUP BY. You usually write it with AS, such as SELECT salary * 12 AS annual_salary FROM employees, though AS is optional in many systems. The alias exists only for the duration of that query and does not change the actual table schema.