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'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What is the difference between automation tools and management tools?
How do you plan test automation?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
Give some examples for defect management tools?
What is the purpose of the wrun.ini file?
What is an automated test script?
What is hybrid automation?
What kind of tests should not be automated?
What kinds of annotations are used in testng?
Tell me how can we find the value of different attributes like name, class, value of an element?
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
What are the advantages of manual testing and automated testing?
What is a critical bug in a testing field?
I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this