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 are the attributes of the cursor?

1059

---

What are advantages of dateset in datastage?

2309

---

How to lock and unlock a user account in oracle?

1162

---

What is a subquery in oracle?

1168

---

How to change user password in oracle?

1099

---

What is oracle join syntax?

1063

---

What are the various constraints used in oracle?

1097

---

What is the sql query to concatenate column values from multiple rows in oracle?

1105

---

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

1046

---

Can objects of the same schema reside in different tablespace?

1103

---

How to fetch the row which has the max value for a column?

1046

---

What do you mean by cdb and pdb in oracle 12c?

1101

---

is there a tool to trace queries, like profiler for sql server?

1198

---

What are operators in oracle?

1103

---

List the various oracle database objects?

1111

---