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 an Extension of entity type?

886

---

What do you mean by flat file database?

975

---

What does n tier mean?

783

---

What is database architecture? : sql server architect

938

---

What is master database? : sql server architect

939

---

State about the security aspects of stored procedures?

1018

---

What is model database? : sql server architect

939

---

What is difference between two tier and three tier?

900

---

What is the meaning of 3 tier?

856

---

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

768

---

What are pages and extents? : sql server architect

859

---

What is durability in DBMS?

951

---

What is RDBMS KERNEL?

1128

---

What is the difference between 3 tier and 3 layer architecture?

851

---

How many types of stored procedure?

898

---