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 Registry?

2159

---

can anyone help me regarding testing patterns?

2079

---

Where we have to use perl scripting in Testing approach and its importance

2225

---

Explain severity with example and expalin each example?

4496

---

define risk management system with example ?

2013

---

Please Provide me the link to download Testing Category questions and answers If some body has downloaded it pleae send it to me Pavan : Email pavan_cd@yahoo.com Quetion2 : Can any body Explain me about Testing thumb rules

2170

---

I am having 2 years of experience in Manual Testing, 2marrow I have an interview with a Company. Which type of questions they will ask me?How should I prepare for interview?Please guide me so that I will clear the interview.

2254

---

How does compatibility testing differ while testing in Internet explorer and testing in Firefox?

3361

---

Can you explain calibration?

1201

---

Different types of design diagrams that supports to write test cases ?

2394

---

what do you mean by Develop test data through sourcing (or) handcrafting techniques

2917

---

I HAVE AN INTERVIEW IN A SOFTWARE COMPANY FOR THE POST OF FUNCTIONAL TEST ENGINEER. THEY WANT THE PERSON FROM BCOM BACK GROUND( I AM A BCOME GRADUATE 2006) AND THE PERSON SHOULD HAVE GOOD ACCOUNTS KNOWLEDGE. NOW I WANT TO KNOW WHAT KINDS OF QUESTIONS THEY CAN ASK OR CAN GIVE IN WRITTEN TEST. I M NERVOUS COZ ITS BEEN 5 YEARS I HAVE DONE BCOM. SO HOW SHUD I PREPARE FOR INTERVIEW.PLEASE HELP? reply me pls. its urgent. thanks

2072

---

what are all the possible Test Cases for VoIP based applications

1814

---

Please let me know how to test labels in web application manually and how the testcases would be. Please provide me a sample testcase

1777

---

Can any one share the domain knwoldege of Telecom Jeeva jeevachr@gmail.com

2555

---