how 2 find out nth salary.plz write sql qurires

Answer Posted / yogini_bhosale

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wht is Manual Testing Frame work

1657


What is quality center? How many built in tables does quality center have?

799


What are tools of performance testing?

710


Please can any one tell me 1).Types of reports 2).Types of Meetings.

1307


1.what kind of testing have you done ?

2369






What is formal testing?

672


What is integration level testing?

695


what is the testing approach for windows Explorer(Not IE Explorer)

2246


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

1568


what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???

1580


What is deferred status in defect life cycle?

711


what is dib format?

1472


What is frame level testing and how do we test it?

1964


What is the Testing strategy for testing client server applications/products?

1824


1.How to maintain the Bug status Report? 2.What is project based Company and product based company?

7082