Informatics Practices

Shikha has written the following SQL statement:

Select Name, Dept, Salary*12 as "Annual Salary" from EMP;

What is "Annual Salary" in the above statement?

SQL Queries

1 Like

Answer

In the given SQL statement, "Annual Salary" is an alias for the calculated column Salary*12. An alias is a temporary name given to a column or table in an SQL query, making it easier to reference and display the results.

Answered By

3 Likes


Related Questions