Which SQL statement generates the alias Annual Salary for the - ProProfs Discuss
Topics
Products
Follow Us:

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

This question is part of Oracle_test4
Asked by Aiswarya, Last updated: Mar 26, 2020

+ Answer
Request

1 Answer

John Smith

John Smith

Answered Jan 13, 2017

SELECT ename, salary12 "Annual Salary" FROM employees;
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.