how to get top two salaries from employee tables

Answer Posted / charan

hi this is charan,
select e1 *from employees e1
where 2>
( select column(distincte2.sal)
where e2.sal>e1.sal )

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain usability testing?

693


Can any one give a summary of testing a territory management system? what would be the test scenarios, few test cases. how it works.

1523


Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.

1637


What is severity and priority of bug? Give some example.

657


please send me database stored procedure checklist.

2432






What is an exit criteria?

652


hi this is chik here iam showing my current project ERP and am prepair in hr model please tell me details about it and what all function test in hr model and give me some test caserelated to this module.Please tell me am faceing lots of problem in interview am not able to explain in interview please help me out my id is chiku_69@yahoo.in

1521


Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also

1581


What are the different servers and difference between them?

1606


Tell me a critical defect in which your Client,PM,PL appreciate on you

1475


What is reverse engineering?

734


What are the challenges you faced in your project (Testing) and in your company?

2591


write test cases on wall

1711


how to connect your project in database?

1511


What are joins and subjoins in the data bases what is data driven testing what is verification and validation What is Quality Assurance (QA) and Quality Control (QC) Is Verification is related to QA and Validation is related to QC ? which type of model you follow basically in your project what is a use case How to test a Bike how to test a Lift (Elevator). which configuration Management tool do you use which Bug tracking tool do you use explain Bug life cycle what is Regression testing what is ALPHA testing ans BETA testing What types of testings comes under Non functional testing what is TEST DIRECTOR what is CMM and CMM i whar are Expressions in Winrunner What is a Compile module Is it Necessary to open the tool first or the application first after getting a bug what will you do if you add a new object or a new module for the existing application then how will you test the application which Defect tracking tool do you use what is change management What is smoke Testing what is sanity testing A application is given to you but the requirements and functionalities are missing what will you do to start the testing which testing documents will be received by the client

1915