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

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

1091

---

How to check the oracle tns settings?

1087

---

What are a query and state the different types of queries and their uses?

1064

---

What happens in oracle commit?

1079

---

What are the built-in functions used for sending Parameters to forms ?

3434

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2345

---

Explain an extent?

1154

---

What are the types of partitions in oracle?

1078

---

Is a rollback possible to any savepoint?

1153

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4233

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2147

---

What is oracle rowcount?

1145

---

Explain oracle insert into command?

1158

---

What is a trigger and what are its types?

1328

---

How to create a table index in oracle?

1184

---