Answer Posted / saraswathi muthuraman

SQL> select * from emp_test order by sal desc;

1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11
1004 99 11
1005 50 11
1006 25 11

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

1004 11 99 5

What is a business logic layer?

776

---

What is temp db database? : sql server architect

833

---

What is Relationship set?

828

---

What is the meaning of 3 tier?

762

---

what is the difference between LENGTH AND SIZE?

2448

---

What is internal database?

960

---

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus

743

---

What is DDL (Data Definition Language)?

853

---

What is an Entity?

822

---

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

810

---

What is 2 tier 3 tier architecture?

826

---

Which part of the RDBMS takes care of the data dictionary? How

983

---

What is model database? : sql server architect

848

---

What is the Disadvantage in File Processing System?

823

---

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

768

---