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 anyone give me a sample bug report, Iam right now taking training on Testing Tools.

5 Answers  

1Testing process followed in your company … 3. Testing Methodology 4. Where u maintains the Repositories? 5. What is CVS? 6. Bug Tool used? 7. How will you prepare traceability matrix if there is no Business Doc and Functional Doc? 8. How will you validate the functionality of the Test cases, if there is no business requirement document or user requirement document as such… 9. Testing process followed in your company? 10. Tell me about CMM LEVEL -4 …what are steps that to be followed to achieve the CMM -IV standards? 11. What is Back End testing? 14. How will u write traceability matrix? 15. What is CVS and why it is used? 16. What will be specified in the Defect Report…? 17. What is Test summary Report…? 18. What is Test Closure report…? 21. What are the Testing methodologies that u have followed in your project ? 22. What kind of testing that u have been involved in and explain about it…. 24. What is joins and what are the different types of joins in SQL and explain the same? 25. What is Foreign Key in SQL…?

2 Answers   QA,

Mapping the test cases with the requirement. What is this process called?

6 Answers   iSoft,

what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important

0 Answers  

What do u mean by Positive and Negative testing & whatz r the diff's between them .Can anyone explain with an example .

4 Answers   AZTEC,

Write a Test Case to test Can of Coke?

1 Answers   Adidas,

What are the positive and negative testing can be done to social site like orkut?

3 Answers  

If Interviewer asks "Do you want to ask any question to us?" Which questions should we ask to them?

2 Answers   Hyundai, Patni,

What is the difference between Shakeout, Smoke, and Sanity Testing.

5 Answers  

How to test back up and storage products?

0 Answers  

How do you test a web application for dump and deaf??

0 Answers   ACS,

what is the difference between 2-tier appli. and 3-tier appli. testing

3 Answers