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
- 3532 Views
- I also Faced
- E-Mail Answers
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
How to drop a tablespace?
Give the various rollback segment states.
Difference between the “verify” and “feedback” command?
What's dateware house and what's clustor with practicle example
What are the oracle built-in data types?
Can I create users through internet explorer in oracle 10g?
How to define a record variable to store a table row?
What is oracle used for?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Is there a combination of "like" and "in" in sql?
What are temporal data types in oracle?
What are the different editions of oracle?
How to convert numbers to characters in oracle?
Point out the difference between user tables and data dictionary?
State some uses of redo log files?
