Answer Posted / janmejaya

select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary




Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It

How to use subqueries with the in operator using oracle?

1137

---

How to define default values for formal parameters?

1095

---

Who developed oracle & when?

1058

---

Explain database link?

1175

---

How do I uninstall oracle 11g?

1176

---

How to enter a new row into a table interactively?

1049

---

Explain oracle instance.

1233

---

How to delete a column in an existing table?

1130

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2044

---

Explain the use of constraints option in exp command.

1082

---

Explain oracle’s server parameter file.

1041

---

Can objects of the same schema reside in different tablespace?

1103

---

What is the use of aggregate functions in oracle?

1071

---

What are internal user account in oracle?

1055

---

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

1065

---