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;

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

---

what is the syntax of CREATE command?

8 Answers  

---

What do you mean by redo log file mirroring?

0 Answers  

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

What is MTTR advisor in Oracle?

0 Answers   MCN Solutions,

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,

---

What is an oracle?

0 Answers  

---

what is a cartition product?

4 Answers  

---

Differentiate between function and procedure in oracle.

0 Answers  

---

What is a Garbage Collection? and what is full recursive Garbage collection?

0 Answers   RBS,

---

What are steps required to ENTER DATA INTO DWH?

2 Answers  

---