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

Define brain stromming?

643


Write the test cases for yahoo home page

1693


What is Application Performance testing and Operational performance testing

1580


What is benchmark testing? hi friends... can anyone suggest the correct answer plz...

3189


What is the difference between authentication and authorization in web testing?

718






wat are the questions would the project leader ask about the project?? please do send the answers early.

6557


what are the advantages of manual and automation testing ? and which one would u term as efficent testing and effective testing ?pls do reply thankx in advance

1445


Define performance and stress testing?

744


What is an exit criteria?

667


How to explain a banking project in interview ? like project discription is Client Online Banking Application provides access to information relating to Banking Online Services provided by Axis to View daily customer transactions, Current and Previous customer statements, Transfer funds from Chequing and Savings accounts ................ From interview point of view can any one explain this project in laymans language

10006


if yahoo ceo asks you to do performance testing for yahoo site, what are the inputs you ask from them?

1631


How much the bug is affecting the functionality of the application?

641


hi all I have an overall experience of 12 years working in an EDP setup(worked in a manufacturing setup in a German MNC). On my request, I was relieved from my duties in Sep 06 for maternity reasons. However I would like to pursue a career in a software organization as a manual tester. I obtained my proficiency certificate in Software Testing from STAG SOFTWARE LIMITED 2 months ago i.e in May and would now like to continue working in this field. However I am unable to find a job until now. If anybody knows of a opening at bangalore, kindly let me know.

1562


Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1621


You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.

2100