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

Answer Posted / upali tejale

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

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

551


Do you know what is functional testing?

566


What are the different types of locks in mainframe?

493


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.

4688


What is junit annotation?

545






Tell me what is a keyword-driven framework?

504


Elaborate the scripting standard while executing testing

511


What is the deference between automation tools and management tools?

542


How software testing is handled?

501


What is test tool?

572


Tell me what is the testng.xml file used for?

517


Explain how to perform load-testing?

599


What type of scenarios can't be automated?

562


what is the advantage and dis-advantages of using framework ?

1776


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

489