Answer Posted / gaurav

try this

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

Describe the types of sub query?

939

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2190

---

Explain integrity constraints?

1060

---

various types of hints and their usage

2627

---

Explain about achiever in sql?

981

---

How to estimate disk space needed for an export job?

992

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1999

---

Can we create database in oracle using command line ?

1031

---

What is a trigger oracle?

1038

---

Why is oracle used?

881

---

How to list all indexes in your schema?

1034

---

How to best split csv strings in oracle 9i?

986

---

What happens to the indexes if a table is recovered?

944

---

How do we create privileges in oracle?

993

---