Answer Posted / naresh

Here it is the simple solution.

Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2

Should Work
Cheers!
Naresh

Describe varray?

1038

---

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

1039

---

How to return top 5 rows in oracle?

1034

---

Can you assign multiple query result rows to a variable?

966

---

What is oracle update statement with inner join ?

1033

---

What is literal?

987

---

How to start your 10g xe server from command line?

1056

---

how the indexes are stored in the Oracle Database?

2257

---

Why is oracle used?

922

---

How will you write a query to get a 5th rank student from a table student_report?

1844

---

Explain the blob datatype?

1057

---

How to connect asp pages to oracle servers?

1054

---

What is a data dictionary and how can it be created?

1117

---

What is max rowid in oracle?

1003

---

Is oracle a programming language?

970

---