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

Do you know what is a xpath?

536


What are the advantages of test automation?

566


What are the different types of an automation tool that you are aware of?

564


Elaborate the situation where automation testing can’t be used for agile methods?

497


What are pros and cons of automating tests at ui layer?

541






What is a critical bug in a testing field?

538


How do you decide which tool you have to use?

544


Tell us what is junit? And what is junit annotation?

512


Write a short compiled module which selects random numbers?

528


When is automation testing useful?

540


What are the limitations of automating software testing?

1501


How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.

4677


Tell me an example of the languages supported by webdriver?

667


What are the different types of scripting techniques for automation testing?

533


When you will not automate testing?

552