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;

He has given table attributes- empid,empfirstname,emplastname,MangerID.And he asked write query to display empfirstname and mangername?

3 Answers   Cap Gemini,

---

What is the diff between CLient, Customer and End User?

7 Answers   JVS, Societe Generale,

---

what is Gui testing and how is it performed

2 Answers   HCL,

---

what is difference between BVA and Equivalence Partitioning ? can u explain BVA for three digits?

2 Answers   HTC, Icon,

---

Neelima, Can you please brief what are the 15 testing issues. I'm aware of 5 Software developement life cycle.

3 Answers  

---

what is the difference between product and application?

6 Answers   Synergy,

---

What is Application Performance testing and Operational performance testing

0 Answers  

---

wat is ur involvement in test plan

4 Answers   CTS,

---

difference between sanity testing and smoke testing?

6 Answers   Cognizant,

---

11. Do any of the authoring tools you use have features to help make your Web sites accessible?

0 Answers  

---

How many scripts u use to run daily?

1 Answers   HCL,

---

When should you begin testing?

5 Answers   Wipro,

---