Write a query to find second highest salary of an employee.
Answer Posted / dyson
select * from employee where
salary=(select max(salary) from employee where salary <(select max(salary) from employee))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
what is the advantage and dis-advantages of using framework ?
Tell me what criteria do you consider for automating a test?
What is a ‘test plan’? What is a ‘test case’?
Elaborate the fields in bug report in automated testing
What is the purpose of getoptions() method?
How do you identify the test cases which are suitable for automation?
Explain me which web driver implementation is the fastest?
what is dynamic window and dynamic model ? (worksoft automation tool)
is anybody suggest me which one is the best testing institute in ameerpet hydrabad
Explain what is the difference between findelement () and findelements ()?
What are the important modules of an automation testing framework?
What are the primary features of good automation tool ?
Tell me what is automation testing?
What are the most popular tools for automation testing?