Answer Posted / gaurav

try this

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

What are set operators?

644

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

586

---

How to store only time; not date and time?

555

---

What are the limitations of check constraint?

569

---

What is meant by joins?

621

---

---

Give the advantages and disadvantages of clusters.

571

---

How to sort the query output in oracle?

608

---

What is recovery manager in Oracle?

589

---

What is ordinary table in oracle?

650

---

How to retrieve data from an explicit cursor?

557

---

What is the parameter mode that can be passed to a procedure?

571

---

What is oracle database client?

553

---

What are the various constraints used in oracle?

552

---

What is the best way to do multi-row insert in oracle?

561

---

What is truncate oracle?

529

---