Answer Posted / yaseen syed

select *
from
(select empno,ename,sal,rank() over(order by sal desc)
ranking from emp)
where ranking=2;

and u can find the nth highest sal by replacing 2 by your
number

How to use null as conditions in oracle?

1125

---

How can we create the complete backup of data in the oracle.

2199

---

What privilege is needed for a user to create tables in oracle?

990

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2000

---

What happens if the update subquery returns multiple rows?

1169

---

What is the use of file param in imp command?

1215

---

How to create tables for odbc connection testing?

1205

---

How can Oracle users be audited?

1170

---

What is a package in oracle?

1160

---

How do I connect to oracle?

1080

---

How to call a sub procedure?

1147

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3246

---

What is a static data dictionary in oracle?

1190

---

What are the limitations of check constraint?

1075

---

What are joins, explain all types of joins?

2360

---