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 "Annual Salary" FROM employees;
C.SELECT ename, salary*12 AS Annual Salary FROM employees;
D.SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
Answer:B
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 "Annual Salary" FROM employees; C.SELECT ename, salary*12 AS Annual Salary FROM employees; D.SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees