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

What is dual table oracle?

991

---

What are a cluster and non-cluster index?

1018

---

What is a read only transaction in oracle?

1029

---

How to get the Installed Oracle Version Information ?

1128

---

How to create a new table in oracle?

1161

---

What are the oracle built-in data types?

1080

---

How many types of tables supported by oracle?

1079

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2193

---

How to create an oracle database manually?

1091

---

How to use regular expression in pattern match conditions in oracle?

1041

---

What is the scope of a local variable?

1067

---

What is the difference between a primary key & a unique key?

1092

---

How to end the current transaction in oracle?

1032

---

Explain the use of control file?

1113

---

Does oracle database need java?

1013

---