Mark for review 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

Ans:B

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

The advantages of Outsourcing Web Development Services

In the present digital world, acquiring a solid web presence is essential for companies to flourish. A well designed site is much much more ...