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 Equivalence Partitioning and Boundary Value Analysis. Is Boundary Value is subset of Equivalence Partitioning??

2 Answers   Xavient,

---

explain the 5 types test matrics?

1 Answers   Persistent,

---

What type of security testing you will do on banking website.

3 Answers   HCL,

---

what techinques do u follow in suring testing?

1 Answers   ANZ,

---

What is the difference between software Product and Project

14 Answers   AppLabs,

---

What is Test Harness, Anybody can explain in Detail. Thanks in advance.

6 Answers   Siemens,

---

For a Login screen with Username, Password input fields and Enter, Cancel button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.

1 Answers  

---

how do you do qa review

2 Answers   IBM,

---

waht is the quality in your company?

5 Answers  

---

what are the different type of bugs in client server and web based?and what is the difference in testing client server and web based?

6 Answers   Tanla Solutions,

---

Write test cases on Travel bag?

3 Answers   Mastek,

---

what are 5 common problems in software development process?

14 Answers  

---