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

Answer Posted / pradeep kumar

Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)

Is This Answer Correct ?    95 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What type of scenarios can't be automated?

563


What is test tool?

572


wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.

1430


List the five essential types of test steps?

565


What is the deference between automation tools and management tools?

542






if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?

1559


How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

1946


Can you explain me what is object repository?

549


how to map requirements& test cases in quality center ???

2056


Do you know when autoit is used?

563


IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

1871


Tell me how could ajax controls be handled in webdriver?

526


How can we make one test method dependent on other using testng?

529


What kind of tests should not be automated?

550


I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com

3821