Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

A.
SELECT ename, salary*12 ‘Annual Salary’
FROM employees;

B.
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)
FROM employees

C.
SELECT ename, salary*12 “Annual Salary”
FROM employees;

D.
SELECT ename, salary*12 AS Annual Salary
FROM employees;

Explanation:

This SQL statement provides correct syntax to generate the alias Annual Salary for the calculated
column SALARY*12.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


kishan

kishan

Answer is : C

kiahore

kiahore

both c and d correct