Answer Posted / surya

select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);

For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......

if you enter n=nth,it will display nth salary

How to drop a tablespace?

1085

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1955

---

How to load data through external tables?

1189

---

What are group functions in oracle?

1093

---

What are the different windows events activated at runtime ?

2945

---

Give syntax for SQL and ORACLE joins.

1144

---

How do I connect to oracle?

1080

---

What is the difference between view and materialized view in Oracle?

1207

---

How do I connect to oracle database?

1198

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2008

---

Can you have more than one content canvas view attached with a window ?

2371

---

How to connect ms access to oracle servers?

1057

---

What happens to the data files if a tablespace is dropped?

1107

---

How to retrieve data from an cursor to a record?

1156

---

What is the recommended interval at which to run statspack snapshots, and why?

2962

---