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!
Answer / 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 |
What is hot backup and logical backup?
Explain about the analyze command in oracle?
How to define a variable to match a table column data type?
pls explain connect by prior with example and its real time use
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is a Garbage Collection? and what is full recursive Garbage collection?
How to see free space of each tablespace?
What is the difference between Sleep and Wait? (Java)
How to handle a single quote in oracle sql?
What is the Tune Query
What is a data dictionary and how can it be created?
What are the benefits of ordbms?