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 are the unary operations in Relational Algebra?

851

---

What are the primitive operations common to all record management systems?

990

---

What is master database? : sql server architect

887

---

What is database architecture?

709

---

Explain about the return statement?

885

---

What is parallel database architecture?

846

---

What is E-R model?

890

---

What is tier in database?

811

---

How can we call stored procedures inside store procedures?

835

---

What is a checkpoint and When does it occur?

786

---

Describe the three levels of data abstraction?

884

---

What is the difference between a user defined function and a stored procedure?

876

---

Name the buffer in which all the commands that are typed in are stored

818

---

What do you mean by atomicity and aggregation?

912

---

What is system catalog or catalog relation? How is better known as?

858

---