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

Answer Posted / p

select ename from emp where esal=(select max(esal) from emp
where esal<(select max(esal) from emp));

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain how to perform load-testing?

575


is anybody suggest me which one is the best testing institute in ameerpet hydrabad

1725


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

1712


What are the things that one should consider for selecting a project for test automation? For example, stability, etc.

1562


What do you think holds the testers back to do automation? Is there a way to overcome it?

558






Do you know how can we make one test method dependent on other using testng?

556


What are the primary features of good automation tool ?

580


Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?

520


Explain what is the difference between findelement () and findelements ()?

542


How do you choose which automation tool is best for your specific scenario?

552


Explain what is the hybrid framework?

567


How would you test your own element locator?

535


Give some examples for test management tools?

578


Why do you want to keep this kind of information in a separate file and not directly in the code?

593


Which is the best place to learn Loadrunner performance testing in hyderabad ?

1076