Answer Posted / sudheer

Guys Few of you have submitted an optimal query.

select distinct sal from emp A where 3 = (select count(sal)
from emp B where a.sal > b.sal)

However the integer 3 will not give the third highest salary
as expected. Point should be noted that the row starts with
zero.

so the actual result will the fourth highest salary with the
above query.

What is a trace file and how is it created in oracle?

974

---

What is catalog in Oracle?

1265

---

What are a cluster and non-cluster index?

958

---

How do I recompile a procedure in oracle?

912

---

What is an oracle and why it is used?

1080

---

What is raw datatype?

1081

---

What is program global area (pga) in oracle?

960

---

What is the implicit cursor in oracle?

1039

---

How many types of cluster table in Oracle?

987

---

master table and child table performances and comparisons in Oracle ?

2071

---

What is partitioned table in Oracle?

1107

---

defination of bitmap index

2047

---

How to use "in" parameter properly?

1006

---

When do I need to use a semicolon vs a slash in oracle sql?

1028

---

What is blob datatype?

1056

---