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 / 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 difference between foreign key and reference key
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What are the different editions of oracle?
Explain the different normalization forms?
what are corelated subqueries
How to delete an existing row from a table in oracle?
Define the terms primary key foreign key and also the difference between primary and the unique key
How to use "while" statements in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to unlock the sample user account in oracle?
How to name query output columns in oracle?
How to insert a record into a table?