Answer / 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));

Answer / guest

select top 1 salary from(select Distinct top 2 salary from
employee order by salary desc)order by salary

Answer / a sameer

By using alias name too we can generate the query
A and B are two alias name for the employee table name

Query:-

select A.* from employee A where N=(selet count(Distinct
B.sal) from employees B where B.Sal > A.sal);


If any one want 2 or any other salary jut replace "the no."
required in place of N, to get the answer.


Hope might understand

Answer / rafi

Select * from (Select emp.*.dense_rank()over (order by sal
desc) a from emp) where a=&n;

what is ERP? why inventory comes in ERP?

4 Answers   BirlaSoft,

---

whats main working for tester. and developer, and prject manager.

0 Answers  

---

differnce between testing life cycle and bug life cycle?

3 Answers   SoftSmith,

---

what is project testing & product testing, and what is the differene ? plz explan with example

1 Answers  

---

what is performance testing?

2 Answers   Crea,

---

wht is test scenario?

5 Answers  

---

If you are the Test Team Leader and one of the Team Member is not supporting and not working according to your expectations what would you do? how will u handle him?

3 Answers  

---

What is the exact difference between retesting & regression testing? Please advise in detail

7 Answers   IonIdea,

---

what r the requirments & inerview questions for the test lead in testing?

1 Answers  

---

in real time, which test case format we r using?

9 Answers  

---

What is Retesting & Regression Testing? When do we use retesting & regression testing(i.e In what situation)? Please clear me.

6 Answers  

---

How do you carry usability testing?

5 Answers   ADITI, CTS, GrapeCity, Intel,

---