Remember
Register
1
new
Chill
new
Puzzles
new
GK
new
Sports
new
Business
Home
Questions
MCQs
Unanswered
Tags
Users
Ask a Question
Write Article
Articles
Connect to us
How to display employee name and annual salary for all employees?
+1
vote
1,771
views
How to display employee name and annual salary for all employees?
sql
oracle
posted
Jun 9, 2015
by
Suchithra
Share this question
Your comment on this post:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
1 Answer
0
votes
Select employeeno,employeename,12*sal+nvl(comm,0) annualsal from employee;
answer
Jun 11, 2015
by
Shivaranjini
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Your answer
Preview
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Similar Questions
+1
vote
How to display name and salary for all employees?
+2
votes
How to display the names of all employees working as clerks and drawing a salary more than 3000?
+1
vote
How to display the name and job for all employees?
+2
votes
How to display employee number and names for employees who earn commission in Oracle?
+1
vote
Display employee number and total salary for each employee in Oracle?
...