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 would you begin to troubleshoot an ORA-3113 error?

2023

---

Differentiate between function and procedure in oracle.

1018

---

What is a sub query? Describe its types?

963

---

How would you change old and new values in an insert, delete and update triggers?

951

---

How to define a cusotmer as a supplier in ORACLE R12

2169

---

How to count groups returned with the group by clause in oracle?

1011

---

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

4114

---

What is the sql query to concatenate column values from multiple rows in oracle?

996

---

How to add a new column to an existing table in oracle?

1069

---

Query to retrieve record for a many to many relationship ?

2458

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2088

---

How to create a testing table in oracle?

945

---

How to connect to the server with user account: sys?

969

---

What is Java Pool in Oracle?

1090

---

Which are the five query types available in oracle?

895

---