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

Can Anybody tell me What is diff. in Win2k namd Win-XP Thanks in advance

2 Answers   Emptoris,

what is the diff between testing and debugging

7 Answers  

What is the database testing?

5 Answers   Wipro,

List 5 words that best describe your strengths.

5 Answers  

What is the main use of the quality center comparing to the excel sheet?

3 Answers   Cognizant,

What is the V-Model Development Method and do you agree with this model?

2 Answers  

NOte pad Testing Q : How to test the notepad "Font size" and "Word Wrap" Options. How to test the relation between these two option.

2 Answers   Ness Technologies,

An Web Application is added with two new features. what will be your test approach? Please guys tell me the answer?

2 Answers  

what is cause effect graph?

2 Answers   Infosys,

If I have written the test cases for Login window . If one new field is added to login window then steps of test case changed in the next build. my question is that should I make change in the steps of previous test case or write another test case with new steps?

1 Answers  

define:usecase?

4 Answers  

3.if a questions asked as,what is the quality standards you are following? what i need to tell.

0 Answers