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
- 3477 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 |
what is the syntax of INSERT command?
what is the exact definition for pointer?
What happens if you lost a data file?
20. Using a set operator, display the client number of all clients who have never placed an order.
Explain the use of grant option in exp command.
Explain joins in oracle?
what is the syntax of SELECT command?
what are views?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Which are the five query types available in oracle?
What is enter substitution variable in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Oracle General 
