Answer Posted / rajdevar

Guys
i have executed this query in sql plus.This is correct

Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)

where n=3

reason for using n-1 is below:

1.We are using correlated sub query.so sal value from each
row in outer query(EMP_USER A) is compared with sal of all
the rows in EMP_USER B

eg:
ENAME SAL
----- -----
SMITH 800
KING 5000
FORD 3000

here third highest is 800.so when executing this 800 from
outer query is compared with 800,5000,3000 in inner query
which returns a count(distinct(sal) = 2

if you use n instead of n-1 you get a empty result.

Let me know if this is correct

How does oracle handle read consistency?

1097

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2709

---

What happens if the update subquery returns multiple rows?

1116

---

Can we write dml statement in function in oracle?

1082

---

How to view the tablespaces in the current database?

979

---

How to initialize variables with default values?

1244

---

How to convert characters to times in oracle?

1023

---

What happens if recursive calls get out of control?

1082

---

What is Reduced List of Values?

2167

---

How to rebuild an index in oracle?

1028

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2265

---

How to loop through data rows in the implicit cursor?

1074

---

How to set a transaction to be read only in oracle?

1093

---

How to write date and time interval literals in oracle?

1036

---

What is raw datatype?

1136

---