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

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2297

---

Can we write insert statement in function in oracle?

1025

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4471

---

What are the oracle differences between nvl and coalesce

1064

---

What are the differences between lov and list item?

989

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1813

---

What is object data modeling?

903

---

What is oracle datasource?

919

---

What is oracle used for?

966

---

Can we use bind variables in oracle stored procedure?

896

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2288

---

How many types of auditing in Oracle?

979

---

What is Reduced List of Values?

2098

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2066

---