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
- 3460 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
Where is the export dump file located?
What is dynamic proxy?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How do we represent comments in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Why cursor variables are easier to use than cursors?
Is there a function to split a string in plsql?
Which is better Oracle or MS SQL? Why?
How to connect ms access to oracle servers?
What are the common oracle dba tasks?
How to count duplicated values in a column in oracle?
How to start an oracle instance?
Is oracle a relational database?
What is meant by an index?
How does the on-delete-cascade statement work?
