Answer Posted / saraswathi muthuraman

Try this :

SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test group by
emp_no,dep_no,sal) where rank_list =5;

1005 11 50 5

This seems to be a correct answer if few employ having same sal

What do you mean by atomicity and aggregation?

912

---

Explain about recursive stored procedures?

812

---

Explain what are the restrictions that views have to follow? : sql server architect

840

---

What is Data Model?

998

---

Explain about the implementation of stored procedures?

885

---

What is Functional Dependency?

802

---

What is an Entity?

863

---

How many types of stored procedure?

857

---

What is VDL (View Definition Language)?

1016

---

What is durability in DBMS?

920

---

What is internal database?

994

---

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

823

---

What is parallel database architecture?

846

---

State about the security aspects of stored procedures?

989

---

Does storing of data in stored procedures increase the access time? Explain?

1126

---