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 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
Why do we use bulk collect in oracle?
How is it different from a normal table?
What is integrity and what is constraint??Explain with example
How to work with data objects interactively?
How can we create the complete backup of data in the oracle.
What is different types of joins?
Explain index?
Explain coalesce function?
What is the difference between translate and replace in oracle?
What is a tns service name?
How many file formats are supported to export data?
How to view the data files in the current database?
What is the database name in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What are the different editions of oracle?