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

What is the data pump import utility?

969

---

Explain alias?

1081

---

How to get a list of all user accounts in the database?

1035

---

what are bitmap indexes? How does they work?

2184

---

Explain the function of optimizer in oracle?

1057

---

How many file formats are supported to export data?

1139

---

How to display employee records who gets more salary than the average salary in the department?

999

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2320

---

How to check the server version in oracle?

1035

---

What are the benefits of ordbms?

1024

---

how can we store any pdf file in oracle

2096

---

How can you use check constraints for self referential integrity?

920

---

What is the difference between translate and replace in oracle?

1115

---

What do you mean by a tablespace?

981

---

What is the difference between post-database commit and post-form commit?

1108

---