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 Functional Dependency?

799

---

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

981

---

What is Relational Algebra?

891

---

What is the job of the information stored in data-dictionary?

804

---

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

1013

---

What do you mean by flat file database?

913

---

What is 2 tier 3 tier architecture?

848

---

What is degree of Relationship type?

851

---

Illustrate physical database architecture in brief? : sql server architect

760

---

What is an Entity type?

851

---

What is the difference between a user defined function and a stored procedure?

866

---

What is database architecture? : sql server architect

885

---

What is E-R model?

882

---

What is DDL (Data Definition Language)?

882

---

What are the the Advantages of DBMS?

845

---