Answer Posted / nitin bisht

SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))

What are the most common databases?

914

---

What does currency type mean in database?

1128

---

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2193

---

What is a driver in database?

1071

---

Explain various types of locks in a transaction? Which is better and why?

979

---

What does specialization in DBMS mean?

1099

---

What is the advantage of varchar2 over char?

1214

---

List various types of log-based recovery in DBMS.

939

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2501

---

What is the purpose of firebase?

932

---

What is table scan and index scan?

1074

---

can u combine pipeline parallelism and partition parallalism? how and whan?

2273

---

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2451

---

What is the role of tester in discovery(in Checklist)?

1921

---

What is the function of cluster index?

1095

---