Answer Posted / chandra shekhar

Assuming that EMP table with Sal column

SELECT MIN(sal) FROM
(SELECT DISTINCT sal FROM emp WHERE
ROWNUM < 6
ORDER BY sal DESC )

- If fifth highest then ROWNUM < 6
- If n'th highest then ROWNUM < n+1

Regards
J

What is end user data?

724

---

What is database architecture?

659

---

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1483

---

What is Relationship type?

843

---

What is 5NF?

775

---

Are the resulting relations of PRODUCT and JOIN operation the same?

780

---

What is DML (Data Manipulation Language)?

822

---

What is System R? What are its two major subsystems?

745

---

What is Data Independence?

847

---

What is temp db database? : sql server architect

813

---

What is single tier architecture?

747

---

Explain logical database components? : sql server architect

710

---

What is the difference between stored procedures and stored functions in oracle?

814

---

Describe the three levels of data abstraction?

829

---

What is DDL Interpreter?

900

---