Answer Posted / harmeet

Hi, this query will gives the third highest salary from table

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.

I hope i'm not wrong.

How to work with data objects interactively?

991

---

What are the common oracle dba tasks?

1152

---

What is pragma autonomous transaction in oracle?

1074

---

master table and child table performances and comparisons in Oracle ?

2138

---

What is bulk copy or bcp in oracle?

1124

---

What is the difference between Delete, Truncate and Drop in Oracle?

1131

---

How to update values on multiple rows in oracle?

1036

---

How to use like conditions in oracle?

1062

---

Difference between cartesian join and cross join?

1051

---

How to sort the query output in oracle?

1028

---

What is difference between sid and service name in oracle?

962

---

query optmization techniques and quwry analyser+projects+ppts

2425

---

What are the different types of modules in oracle forms?

1001

---

How to get execution statistics reports on query statements?

1103

---

Can we create trigger on materialized view in oracle?

998

---