Answer Posted / chanchal

SELECT MIN(salary) FROM Department WHERE salary IN
(SELECT TOP 3 salary FROM Department ORDER BY salary DESC)

What is define in oracle?

565

---

Why does for update in oracle 8 cause an ora-01002 error?

544

---

Explain how are indexes update?

621

---

What is program global area (pga) in oracle?

605

---

How to check the server version in oracle?

611

---

---

How to empty your oracle recycle bin?

573

---

Can group functions be mixed with non-group selection fields?

534

---

What is the sid in oracle?

536

---

How to return top 5 rows in oracle?

547

---

What is an oracle?

577

---

How to convert dates to characters in oracle?

583

---

What types of joins are used in writing subqueries?

567

---

What is merge statement used for?

568

---

How to run the anonymous block again?

595

---

Can the query output be sorted by multiple columns in oracle?

573

---