Answer Posted / utkal

Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).

Here n=2,

Similarily we can find the 5th highest salary etc...

How do I manually create a database in oracle?

1026

---

How to concatenate two text values in oracle?

1118

---

How to rebuild an index in oracle?

1032

---

How to execute the package in oracle?

1089

---

Explain the use of compress option in exp command.

1026

---

Does oracle charge for java?

1062

---

Difference between cartesian join and cross join?

1056

---

Please explain oracle left join with an example?

1054

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1092

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2503

---

Explain the difference between replace() and translate() functions in oracle?

1044

---

Difference between the “verify” and “feedback” command?

1374

---

State and explain about oracle instance?

1004

---

Is it possible to insert comments into sql statements return in the data model editor ?

2572

---

Explain the use of log option in exp command.

1127

---