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
- 3395 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 |
How to use like conditions in oracle?
What are various joins used while writing SUBQUERIES?
How to restrict the duplicate records in table valuesets
Can u make a synonym for deptno=10 only from emp table.
What is a database table in oracle?
Is insert autocommit in oracle?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Can the default values be assigned to actual parameters?
Explain the importance of .pll extension in oracle?
What happens to the current transaction if a ddl statement is executed?
How to use subqueries with the in operator using oracle?
what are the things that you consider while creating indexes on partitioning tables?
Oracle General 
