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
What is a package ? What are the advantages of package ?
What is Virtual Private Database in Oracle?
What privilege is needed for a user to create indexes in oracle?
Explain what are synonyms used for?
What is the dynamic sql in oracle?
How to select some columns from a table in oracle?
How to rollback the current transaction in oracle?
how may join possible between (requisition with purchase order)
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to run the anonymous block again?
What do you mean by a deadlock?
What is the difference between 10g OEM and 11g OEM?
How to change user password in oracle?
What is the difference between sharding and partitioning?