Write a query to find second highest salary of an employee.
Answer Posted / ravi
I write this query and it run !!
SELECT max(salary) FROM Employee WHERE Employee.salary <
(SELECT max(salary) FROM Employee)
Plz reply if anyone having generic answer. :-)
Thanks
| Is This Answer Correct ? | 313 Yes | 56 No |
Post New Answer View All Answers
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
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.
How to check if an element is visible on the page?
Have you completed the cps exam? Which one?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
Do you know what is a xpath?
Discuss the economics of automation and the role of metrics in testing.
8. How we test web based application
List some advantages and disadvantages of automation testing.
Tell us which package can be imported while working with webdriver?
What are the different types of locks in mainframe?
What should you do after finding a bug?
Is automation testing a complete replacement for manual software testing?
how to map requirements& test cases in quality center ???
HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?