Which SQL statement generates the alias Annual Salary for the - ProProfs Discuss
Advertisement

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

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?<br/>

Change Image    Delete

Asked by Aiswarya, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

John Smith

John Smith

John Smith
John Smith

Answered Jan 13, 2017

SELECT ename, salary*12 "Annual Salary" FROM employees;
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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