Answer Posted / lingareddy

select top 1 salary from (select distinct top 5 salary from emp order by salary desc ) a order by salary asc


if u have any doubts in SQL kindly reach with me,

Thanks & Regards,
Lingareddy.S
sabbasani.reddy1@gmail.com

How to view the tablespaces in the current database?

927

---

How to create a stored function in oracle?

1037

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

916

---

Will you be able to store pictures in the database?

1062

---

What do you know about normalization? Explain in detail?

879

---

What is an oracle user account?

930

---

Can we store pictures in the database and if so, how it can be done?

982

---

How does one get the view definition of fixed views/tables?

967

---

How to export your own schema?

969

---

How do I manually create a database in oracle?

955

---

What is the usage of merge statement?

1095

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1696

---

How to create a server parameter file?

1080

---

What is a data lock in oracle?

1015

---

What is the difference between substr and instr?

977

---