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

Explain about the implementation of business logic in stored procedures?

781

---

Not only RDBMS takes care of locating data it also

845

---

What is difference between 2 tier and 3 tier architecture?

831

---

What are the levels of architecture?

871

---

What is a Phantom Deadlock?

1051

---

What are the 3 levels of data abstraction?

890

---

What is database architecture? : sql server architect

938

---

What is Relationship set?

914

---

can we use transformer in datastage without any input link?

1782

---

What do you mean by Correlated subquery?

909

---

Explain what are the database objects? : sql server architect

975

---

How is the data structure of System R different from the relational structure?

888

---

What do you know about system database? : sql server architect

906

---

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?

1579

---

Do you know what the restrictions applicable while creating views are? : sql server architect

838

---