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

How to explain the project? (banking)

1 Answers   CGI,

when we found problem occured in requirement while writing test case when communicate with client but they not accepting it is problem whether you continue further or not?

3 Answers   Aspire,

Are Test Condition and Test Description/Procedure are different? Please Reply

1 Answers  

How do i write a test condition to test the following simple program with the intention of 100% Condition coverage testing Print “Hello World” If Date $ = ‘01-01-2000’ AND Time $ = “00:00:00” THEN Print “Happy New Year” END IF PRINT “The date is = “Date $ PRINT “The time is = “Time $. Could anyone please clarify in detail. Would really appreciate it....

0 Answers  

11. Do you have any other questions or comments about the Web site or your experiences with it?

0 Answers  

what are the factor taken under website testing manually?

3 Answers  

what is functional testing?Explain with one example?And when we use functional testing in your project???

2 Answers   TCS,

what is usuability testing ,when and how is it done

6 Answers  

The project manager is working with the team to help them understand the constraints the project must operate within. As a kick off to the meeting, the manager displays the first slide, which reads: Scope, Schedule and Budget--You may pick two. Based on the above scenario, which one of the project concepts is the manager relating to the team?

2 Answers  

3. How would u test and automate Windows Auto-Update featur

1 Answers  

in SDLC,at what phase life cycle stops?and what are the input and output of each phase?

5 Answers   Tanla Solutions,

What is sanity?

0 Answers