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

whar are the contents in db testing test case template

0 Answers   Reliance,

what is smoke testing?

9 Answers  

what type of questions they asked in symphony company for manual testing?

1 Answers   Symphony, Symphony Teleca,

what all the metrics to be checked for a document ?

1 Answers   Bally Technologies,

What is meaning by protype in SDLC ?

6 Answers  

what is the most critical bug u have to find in ur project.My application is ERP based,in this purchase module is there.plz tell me the answer?

0 Answers   Accenture, Value Labs,

I am having 2 years of experience in Manual Testing, 2marrow I have an interview with a Company. Which type of questions they will ask me?How should I prepare for interview?Please guide me so that I will clear the interview.

0 Answers  

What exactly you do as a Configuration controller?

0 Answers   IBM,

HI Can any one tell me what is the meaning of creation and setup of system input files and execute the tests at the command line

1 Answers  

Do you feel any dis-advantage over the current process? if he/she says any, have You discussed with your Manager reg this ? Why?

0 Answers  

Difference between Web based application and web application

6 Answers   AZTEC, Wipro,

Types of validation Testing?

3 Answers