Answer Posted / abhisudipta

select d.dept_name,e.emp_nm,max(e.sal) as salary
from dept d, emp e
where d.dept_no=e.dept_no and e.emp_nm = (select emp_nm from
emp where sal=(select max(sal) from emp where
dept_no=d.dept_no))
group by d.dept_name,e.emp_nm;

What is oracle and what are its different editions?

1008

---

How to define a specific record type?

1037

---

What is ordinary table in oracle?

1077

---

Is a rollback possible to any savepoint?

1002

---

How to unlock the sample user account in oracle?

919

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2191

---

How to apply filtering criteria at group level in oracle?

987

---

State all possible different index configurations a table can possibly have?

951

---

How to turn on or off recycle bin for the session?

1038

---

What is truncate oracle?

917

---

What are the advantages of oracle 12c?

1121

---

What is PL/SQL ?

1907

---

What are the common oracle dba tasks?

1072

---

What is the minimum client footprint required to connect c# to an oracle database?

1019

---

How to get the Installed Oracle Version Information ?

1075

---