Write a query to find second highest salary of an employee.
Answer Posted / satish
select e1.* from emp e1 where 1=(select count(distinct
e2.sal) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the main differences between Loadrunner and QTP tools? Describe briefly a "real world" scenario that would make you use the first one versus the other? Thank you for your answers....
can any one tell me the examples of white box testing
Tell us can we find all links on a web page?
Tell me how could the web element attributes be inspected in order to use them in different locators?
What you know about table-driven testing?
What is a framework for automation testing?
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
What are the risks associated in automation testing?
Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932
Do you know what is selenese?
4. How we implement Winrunner,in our project?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
What are the points that are covered while planning phase of automation ?
List the five essential types of test steps?
What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.