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 release notes?and when it is prepared and who prepares that?.

7 Answers   HCL,

---

What is parallel Testing?

1 Answers  

---

what is a horizontal and vertical matrix explain with examples

0 Answers   BirlaSoft,

---

Does Automation replace Manual Testing?

3 Answers  

---

define risk management system with example ?

0 Answers   ITC Infotech,

---

Functional and Integration test scenarios for actitime application

0 Answers  

---

What is meant by Metrices?What is purpose of Metrices in Testing?What is Template for that?PLZ REPLY ASAP.Thanks in advance.

1 Answers  

---

What is meant by thin point in QTP

0 Answers  

---

What r all the security problems u r facing & the measures taken to solve.

0 Answers   Collabera, TCS,

---

hi,i have just done a 3 days training in software testing,i read and to a certain limit understand the fundermentals but when it comes to real life scenerio i mean working on a job i dont think am confident in the practical aspect. if u feel me pls hola

1 Answers  

---

what is the best defect(functionally relaleted) u find in u r career?

2 Answers  

---

1Who performed sanity and smoke testing :-- developers or testers ? Explain with example and prove ur answer. 2 Company has developed a project for company B, company B has to introduce this project into the market. The acceptance testing is performed at Company B. is it called as alpha testing or beta testing ? Explain with example and prove ur answer.

7 Answers  

---