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 open and close an explicit cursor in oracle?

1031

---

What is blob data type in oracle?

1088

---

Can we write dml statement in function in oracle?

1067

---

What is tns entry?

1110

---

What do you mean by group by clause?

1024

---

How to use fetch statement in a loop?

1006

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2944

---

What is blob datatype?

1099

---

What is coalesce function?

1052

---

State some uses of redo log files?

982

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2337

---

What is tns service name?

1109

---

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

980

---

How to create a new tablespace in oracle?

967

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2280

---