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
---

master table and child table performances and comparisons in Oracle ?

2138

---

11. Display the client number and name and the client number and name of the person who referred that client.

2342

---

What is the usage of save points in oracle database?

964

---

What is oracle open database communication (odbc)?

1030

---

How to view the data files in the current database?

1101

---

How to convert times to characters in oracle?

1027

---

What do you understand by a database object? Can you list a few of them?

1020

---

What is oracle server autotrace in oracle?

1166

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4177

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2215

---

How to filter out duplications in the returning rows using oracle?

1020

---

Explain oracle 12c new features for developers?

1063

---

How to start an oracle instance?

1024

---

What are the numeric comparison operations?

1121

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

---