how to get top two salaries from employee tables

Answer Posted / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between three tier and two tier application?

676


What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?

976


hi... guys can any one pls help me out.... I m civil engg graduate i want to come into s/w field... i have decided to do manual testing course. i know its not sufficient.. which r the other coures shall i do with this.. suggest me good atomation tool and SAP courses... thanks in advance.. i wil be thankfull to u all

1712


difference between change management and configuration management

1584


hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks

1356






how can you test the web environment for security testing?

1453


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

1599


When the GUI Testing will be held on the V model ?

1732


How to do the performance testing manually? Does you have a test case for that?

693


What is security Hole ? Is this possible Some one can acess any of restricted page (like admin side)? How you test this previllaze?

1933


how to creat 2 test plan in 2 different environment exp:tour and travel

1922


What is regression testing? When to apply it?

678


What is fuzz testing?

653


1.Acceptance testing involves procedures for identifying acceptance criteria for interim life cycle products and for accepting them.is that? 2.Acceptance testing occurs only at the end point of the development process; it should be an ongoing activity that test both interim and final products.is it?

1874


List the type of testing perform to test microsoft excel 2003 give atleast 1 example of each type

1442