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

Answer Posted / chandramami

SELECT MAX(e.salary)
FROM emp e,emp e1
WHERE e.salary<e1.salary;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Any one suggest me for Free ware (Opensource) Automation tool for regression testing.

1547


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

1782


22. Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.

1456


What are the points that are covered while planning phase of automation ?

630


explain add in manager and virtual object wizard in winrunner

1667






Explain load testing on websites?

629


I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.

1447


What is a xpath?

575


HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?

1832


How automation process is carried out?

566


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

2065


What are the attributes of a good framework?

578


What kind of tests should not be automated?

560


What are the disadvantages of Hybrid framework

5694


What are the limitations of automating software testing?

1518