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;

If you were given full powers how are you going to change the complete QA process in your company

1 Answers   ADP,

---

what is client server technology?

1 Answers  

---

Can anybody explain me branch/decision coverage with a example.

1 Answers  

---

Can you explain random/monkey testing?

0 Answers  

---

Anybody having documents and URLs about BFSI domain...Please share..it is really urgent

0 Answers  

---

please answer, What is the Gap Analysis?

3 Answers   Yardi,

---

what is the difference between functionality testing and regression testing

5 Answers  

---

how many phases in SDLC

10 Answers  

---

What will be the test cases for login phase in SIT format

0 Answers   CTS,

---

can anyone tell me process of how the bugs r reported by testers??n after reporting bugs is the work of test engineer finished or still he has to do any thing????

1 Answers  

---

Explain defect lifecycle.

3 Answers   Hexaware,

---

what type of report that you print it out from your defect tracking too when you go for the bug triage meetings? Thanks

1 Answers  

---