top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to display employee name and annual salary for all employees?

+1 vote
861 views
How to display employee name and annual salary for all employees?
posted Jun 9, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Select employeeno,employeename,12*sal+nvl(comm,0) annualsal from employee;

answer Jun 11, 2015 by Shivaranjini
...