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
- 3374 Views
- I also Faced
- E-Mail Answers
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 |
How to create an oracle database manually?
Can you tell me how to add new column in existing views?how?How is possible?
What are oracle functions?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to get execution statistics reports on query statements?
What are the arithmetic operations?
How do I manually create a database in oracle?
How to convert times to characters in oracle?
How to see free space of each tablespace?
What is backup in Oracle?
What is a cursor and what are the steps need to be taken?
Can we call a trigger inside a function and function inside a trigger? Give example.
Oracle General 
