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

Which is super key?

767

---

How many types of stored procedure?

792

---

what is the difference between LENGTH AND SIZE?

2429

---

What is raid and what are different types of raid configurations? : sql server architect

836

---

What is a Phantom Deadlock?

904

---

Brief theory of Network, Hierarchical schemas and their properties

783

---

What is DML Compiler?

933

---

What is model database? : sql server architect

831

---

Does storing of data in stored procedures increase the access time? Explain?

1072

---

Explain the microsoft sql server delete command? : sql server architect

748

---

What is parallel database architecture?

795

---

What do data architects do?

766

---

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

747

---

What is Relational Algebra?

840

---

What is DDL Interpreter?

906

---