Answer Posted / shankar

Hi...
here is the query to find out the n'th maximum salary

note: 1.'emp' is Table name & 'sal' is column name.
2.'distinct' is used for finding the unique value
3.'count' is for counting the values.

Query:
------

SELECT * from emp
where sal = (SELECT distinct(sal) from emp x
where &n = (SELECT count(distinct(sal)) from
emp where sal >= x.sal));

What is difference between Manual testing and Pega/BPM testing?

8127

---

*) Internal review defect gets detected… 1) During peer review. 2) By the own stuff member onsite/offshore. 3) During Informal review process. 4) None of these 5) All of these

2224

---

What is bidirectional traceability ??? and how it is implemented

2095

---

Explain Test Plan with example? Explain following in the test plan with examples What is being tested? What are pass/fail criteria? When will each test occur? What Hardware & Software environment is required? What features must be tested? What features will not be tested? What are the responsibilities of individuals & organisation in the project?

2606

---

Differentiate verification and validation?

1276

---

1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?

2509

---

a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh

1860

---

Can you explain the various elements of function points ftr, ilf, eif, ei, eo, eq, and gsc?

1323

---

What is the main use of preparing a traceability matrix?

1145

---

why use caffine for HPLC calibration ?

2109

---

what is mean by Performance Related Testing in data base?

2122

---

What exactly is quality control?

1101

---

What is the difference between functional testing and integration testing?

1237

---

What is positive and negative testing?

1076

---

what is base time , how can we base time your doc"s ?

1914

---