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 do you do if the bug that you found is not accepted by the developer and he is saying its not reproducible.

1173

---

What is the full form of cmmi?

1322

---

Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.

1854

---

Write the function test case to add a customer to database.

2197

---

integration test cases for mouse and keyboard

3733

---

i want to for technical interview question paper along with in tesrviwe Phases i need

1966

---

What is common interface?

1984

---

Sentence "Working from onsite is effective" is growing in IT field. How do we bring that knowledge to offshore and do an effective job in Offshore?

2147

---

Could some one tell me test cases for multi line text boxes like Notes field?

2196

---

What are the uses of test plans? What is the need of test plans and explain their significance

1920

---

qtp9.2 and qtp10.0 difference

3472

---

Test cases on send/ receive button of Microsoft outlook.

4666

---

What type bugs you will find in integration testing with example?

2007

---

How can you do the scalability testing?

1238

---

How to do Pixel Size testing in a PDF document. Is there any Open tool that will be avaiable?

2026

---