how 2 find out nth salary.plz write sql qurires

Answer Posted / a sameer

By using alias name too we can generate the query
A and B are two alias name for the employee table name

Query:-

select A.* from employee A where N=(selet count(Distinct
B.sal) from employees B where B.Sal > A.sal);


If any one want 2 or any other salary jut replace "the no."
required in place of N, to get the answer.


Hope might understand

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Changes and enhancements to system?

1845


How could you present test strategy for the product testing?

870


Is there any procedure of web-site development in manual testing. If yes what are factors we should test?

2158


What are the two main categories of software testing?

954


How to overcome pesticide paradox?

974


What type of questions will be asking for 2 years experience candidate in manual testing?

2050


What type bugs you will find in integration testing with example?

1785


what types of testing you performed in transfer funds module....

1396


How do test documents in a project span across the software development lifecycle?

1434


How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?

1999


What are the advantages of waterfall model?

890


Write all combinations of test cases for calculater on + symbel

2051


what should be tested when credit card is used as payment option in ecommerce project?can anyone tell me in detail what to test n how to test when credit card is involved in web application?

1790


I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in

8932


write test cases on wall

1943