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
- 3402 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 |
what is dynamic SGA and static SGA
What is a Segment ?
Where do we use decode and case statements?
What is an oracle?
What are the types of Database Links ?
Differentiate between function and procedure in oracle.
Is there an oracle sql query that aggregates multiple rows into one row?
What are a cluster and non-cluster index?
Which Oracle App Is Most Popular One ?
How to define a variable to match a table column data type?
How to handle a single quote in oracle sql?
What is Undo Management Advisor in Oracle?
Oracle General 
