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 Query evaluation engine?

1014

---

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

837

---

What are the different phases of transaction?

872

---

What is 2NF?

892

---

What is SDL (Storage Definition Language)?

846

---

What is Data Independence?

938

---

What do you mean by atomicity and aggregation?

955

---

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

972

---

What are the three levels of database architecture?

786

---

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

872

---

What is a two tier wage system?

864

---

can we use transformer in datastage without any input link?

1782

---

What is one tier architecture?

822

---

Where the procedures are stored in database?

887

---

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

1034

---