Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table that log salary-increase-process have
fields: autoid, old_salary, acctno
and table EMP: acctno, name, salary
I want to list count increase-salary of employees, each have
old_salary, new_salary.
Help me with SELECT statement, please!
- 1 Answers
- 3466 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhisudipta
select distinct a.acctno,b.name,a.old_salary,b.salary,
nvl((sum(b.salary)-sum(a.old_salary)),0) count_increase
from salary_increase_process a,emp b
where a.acctno=b.acctno
group by a.acctno,b.name,a.old_salary,b.salary;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many anonymous blocks can be defined?
Is the After report trigger fired if the report execution fails ?
How to run the anonymous block again?
How to bring a tablespace online?
How to run create database statement?
What do you understand by a database object? Can you list a few of them?
How do you find current date and time in oracle?
Where do we use decode and case statements?
How to define a record variable to store a table row?
What is the implicit cursor in oracle?
Which is better Oracle or MS SQL? Why?
What are the execution control statements in oracle?
What is the difference between $oracle_base and $oracle_home?
How to speed up webrick?
Explain a synonym?
