how 2 find out nth salary.plz write sql qurires

Answer Posted / ganesh thik

select * from employee emp1 where 2=(select count (emp2.salary))from employee emp2 where emp2.salary>emp1.salary.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module

1580


what are the types of Bug?

1064


what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???

1584


what is test strategy,test plan and test policy?Does anyone have dummy documents or any links that gives more idea about these?I am a beginner...interested in learning more abt testing.plz help and encourage me........!

1423


can we do database testing in manual testing? then how we write the test case?

5949






can anyone tell me few critical bugs in ecommerce project.

5596


Explain stub in testing point of view?

712


Can any tell me how a clinical data management system is tested? what are the test scenarios? what are the test cases? work flow.

1430


Hi.....wat r d major bugs we can find in banking domain???

1988


1.How can you Pick Integration Test Cases? 2.When will you start Regression Testing? 3.What is the difference between QA & QC? 4.When Will you Exit In Testing? 5.Test Deliverable's 6.What is the difference between windows based appln and web based appln? 7.What are the types of regression testing?

4480


What is virtual creation tool?

1553


What is the difference between web based application and client server application?

5476


What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing

2416


hi i want manual testing interview question(3+exp)please tell me

1500


In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?

1745