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 are the different ways to check a date field in a website?

1157

---

Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com

2052

---

Describe your personal software development process.

2654

---

what is the testing approach for windows Explorer(Not IE Explorer)

2777

---

What is difference in between operating system 2000 and os xp?

1050

---

HI, This question is Investment Banking domain related Question. I was asked in an Interview to tell the 5 test cases for Equity,Bond,Futures and options. Please help.. Pragya

4513

---

I have an Interview about Guidewire claimcenter,so could you provide any info regd it?.I would really appreciate any kind of help- email at hvshah2001@gmail.com

2468

---

What is a maturity level?

1218

---

If we have no srs, brs but we have test cases does you execute the test cases blindly or do you follow any other process?

1208

---

What is baseline testing?

1122

---

A form has four mandatory fields to be entered before you submit. How many numbers of test cases are required to verify this? And what are they?

1163

---

What is grey box testing?

1161

---

what is test case management?explain in brief.

2068

---

Explain Testing process in your organization?

1541

---

You may be overqualified for this position we have to offer

2207

---