Answer / jethva_trupti

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP N salary
FROM dbo.empsalary
ORDER BY salary DESC) a
ORDER BY salary


where N can be any number

Answer / suresh yadav

select * from emp where &n=(select count(distinct(sal))from
emp b where emp.sal<=b.sal);

Answer / ramthiraviyam

In MySQL ,

we can get the nth salary using LIMIT IN MySQL Query .
Example:
if you want to take 7 th largest salary From emp table,

SELECT salary FROM emp order by salary desc LIMIT 6,1

Answer / ganesh thik

select * from employee emp1 where 2=(select count (emp2.salary))from employee emp2 where emp2.salary>emp1.salary.

Answer / sud_aj

Nth Highest salary:

Select Min (salary) from Employees
where
salary IN (Select TOP n salary from Employees order by salary DESC)
Here n= any number

Answer / yogini_bhosale

select MAX (salary from employee)
where
salary not in ( select TOP N+1 salary from employee)
ORDERBY salary desc();

Answer / nagapawan

iam taking table name as emp. this is to find out nth salary
eg: select * from emp
where n-1 = (select count(*) from emp e
where emp.salary<e.salary)

in place of n-1 you can keep zero for first hight salary
and 1 for second hightest salary.....etc

Answer / kishore

SELECT [column_list], ROWNUM
FROM (SELECT [column_list]
FROM table
ORDER BY Top-N_column)
WHERE ROWNUM <= N

what is difference between waterfall model and vmofel?

6 Answers   CTS, HCL,

Is it possible to have a defect with high severity and low priority and vice-versa i.e high priority and low severity? Justify,if possible? give a example?

5 Answers  

How do you determine user load for a performance test of a Web application?

0 Answers  

What r the risks involved in testing?

1 Answers   Wipro,

1.Test cases for Password cannot be used for next 13 times? 2.Test cases for Password should not be less than 8 to 13 chars and there should be at least one special character and one Capital letter.

1 Answers   Satyam,

What are testing techniques? What is difference between general and specific?

0 Answers   Wipro,

how far unix is useful in testing,what the interviewers going to ask in UNIX,how much we have to learn i.e what are the concepts that we have to learn for interview purpose? plz send me the answer

0 Answers  

explain v- model? why we call this model as v-model, not an u-model?

2 Answers  

Hi Friends, What are the steps involved in STLC

16 Answers   Polaris,

i have worked in 11 month duration project. interviewed person asked me for wat purpose you worked in that project and wat you worked. you worked for a long time in one project. its loss for the company you worked.

4 Answers   CTS,

what is the role of test engineer while doing unit and integration testing. unit and integration testing is already done by developers

1 Answers   IBM,

can u explain about iteration model? And what is it?

2 Answers   iNautix,