Answer Posted / amitabh sharma

Here are 2 queries for finding 3rd highest salary:

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


SELECT * FROM
(
SELECT Ename, SAL, dense_Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMP)
WHERE RANKNEW = 3

Regards,
Amitabh Sharma

How to define a sub function?

1084

---

Is oracle a language?

900

---

How to turn on or off recycle bin for the instance?

1012

---

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

971

---

Why is oracle used?

881

---

Give the different types of rollback segments.

980

---

How to experiment a data lock in oracle?

1001

---

Calculate difference between 2 date / times in oracle sql?

987

---

What is a relational database management system?

1064

---

What is define in oracle?

1000

---

How to unlock the sample user account in oracle?

919

---

What to do if the binary spfile is wrong for the default instance?

999

---

How to omit columns with default values in insert statement in oracle?

1000

---

How to retrieve data from an cursor to a record?

1020

---

Respected sir, Please send me technical questions related to oracle apps..

1762

---