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 is the difference between LENGTH AND SIZE?

2484

---

What are the 3 levels of data abstraction?

846

---

What is indexing and what are the different kinds of indexing?

964

---

Explain about recursive stored procedures?

805

---

What are the three tiers in a 3 tier architecture?

774

---

What is a view? How it is related to data independence?

908

---

When is a functional dependency F said to be minimal?

784

---

What is degree of Relationship type?

851

---

What is Lossless join property?

977

---

What is model database? : sql server architect

890

---

What is parallel database architecture?

841

---

What is the difference between "is" and "as" while creating procedure?

814

---

What do you mean by flat file database?

915

---

Explain about the process which takes place to execute a stored routine?

748

---

What is E-R model?

888

---