Answer Posted / mats önnerby

--- Three level query
--- 1. Find and order all distinct salaries
--- 2. Pick the two top salaries
--- 3. Get all information about employees with that salary

select *
from emp
where sal in (
select sal from (
select distinct sal
from emp
order by sal desc)
where rownum <= 2);
---
--- Simple and straight forward but will return
--- several employees in case they have the same salary
---

How to assign a table row to a record variable?

1035

---

How to use fetch statement in a loop?

1019

---

How can we force the database to use the user specified rollback segment?

1143

---

What is meant by recursive hints in oracle?

1084

---

What is logical backup in oracle?

1014

---

How to apply filtering criteria at group level in oracle?

1036

---

How to drop an index?

952

---

How many data types are supported?

1077

---

What do you mean by merge in oracle and how can you merge two tables?

948

---

How to loop through a cursor variable?

1082

---

What is the difference between sharding and partitioning?

984

---

What is open database communication (odbc) in oracle?

1001

---

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.

1995

---

Explain the difference between sap and oracle?

1029

---

how to handle exceptions in post production

1416

---