Write a query to find second highest salary of an employee.

Answer Posted / harikrishna ravipati

select max(sal) from emp where sal <
(select max(sal) from emp)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of the automation framework?

536


How can the user get a text of a web element?

532


What are the drawbacks of test automation?

592


what is dynamic window and dynamic model ? (worksoft automation tool)

1584


hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.

1739






What is junit annotation?

555


what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please

1718


5. What are the tests you are conducting through winrunner?

1992


Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..

1438


Do you think that testing can be done only at the ui level?

618


Tell me what is regression testing?

558


In Selenium how a test suit is run and report is generated.

1960


Which test cases can be automated?

576


What is Sikuli?

624


What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain

1836