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

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

---

What are oracle functions?

976

---

What is truncate oracle?

917

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2075

---

What are the ansi data types supported in oracle?

897

---

master table and child table performances and comparisons in Oracle ?

2071

---

What is archive log in Oracle?

1071

---

Explain cascading triggers.

1013

---

various types of hints and their usage

2627

---

What is a tns file?

942

---

What happens if the update subquery returns multiple rows?

1046

---

How many categories of data types?

940

---

Can we call procedure inside function in oracle?

1021

---

What is columnar storage what is the advantage?

986

---

What is data file?

1046

---