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.
Answer is : C
C
both c and d correct