Answer Posted / gaurav

try this

select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));

How to find out what oracle odbc drivers are installed?

1040

---

What is oracle latest version?

1096

---

How to connect asp pages to oracle servers?

1072

---

How to apply filtering criteria at group level in oracle?

1042

---

Explain what does a control file contain?

1098

---

How to join two tables in a single query using oracle?

997

---

Point the difference between translate and replace?

1085

---

What is difference between truncate and delete?

1040

---

What is a sub query and what are the different types of subqueries?

1125

---

How to download oracle database 10g xe?

1018

---

What are the different types of record groups in oracle? Explain each of them

1025

---

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

1141

---

What do database buffers contain?

1030

---

Why do you use stored procedures and state some of its disadvantages?

1028

---

How to insert multiple rows with one insert statement in oracle?

1086

---