Monday, 27 August 2012

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

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

Ans:B

No comments: