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 difference between selenium and QTP tools Which is best tool... Which is most used tool
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
how to use regular expression in Test Complete Functional tool
Tell me how would you test your own element locator?
If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!
Elaborate the scripting standard while executing testing
What are the points that are covered while planning phase of automation ?
What are the 5 common software development problems solutions?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
How do we Test the C++ and Unix Application Using Automated Tool.
What is the deference between automation tools and management tools?
Tell me what is a keyword-driven framework?
Explain me what is the difference between setspeed() and sleep() methods?
Is automation testing a complete replacement for manual software testing?
What is a ‘test plan’? What is a ‘test case’?