Answer Posted / nirad

select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc


if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3

How do I limit the number of rows returned by an oracle query after ordering?

1175

---

How to convert raw data type into text in oracle? Explain

998

---

How to turn on or off recycle bin for the instance?

1090

---

Can sub procedure/function be called recursively?

1008

---

What is the difference between translate and replace in oracle?

1172

---

State and explain the different types of data models?

950

---

what is IDE,DMV in sql server?

2829

---

How to do paging with oracle?

1005

---

Explain self joins in oracle?

1025

---

What are the different types of record groups in oracle? Explain each of them

1030

---

why dont we assign not null constraint as table level constraint.

2742

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1021

---

How to retrieve data from an explicit cursor?

1066

---

What happens to the indexes if a table is recovered?

993

---

Can multiple cursors being opened at the same time?

1068

---