Write a query to find second highest salary of an employee.
Answer Posted / satish
select e1.* from emp where 1=(select e2.sal from emp e2
where e2.sal>e1.sal)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the different types of an automation tool that you are aware of?
Explain about basics of rational robot - ibm test automation tool?
What all different approaches can be used for designing an automation solution?
Which test cases can be automated?
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)
What is tsl?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
What is test tool?
Please explain how to perform load-testing?
what is critical test case ? please give an example .
What are pros and cons of automating tests at ui layer?
Where to maintain information like login, password and url?
What is the difference between automation tools and management tools?
What are the phases in automation testing life cycle?
what is GDC