Write a query to find second highest salary of an employee.
Answer Posted / lokesh kanithi
Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)
| Is This Answer Correct ? | 27 Yes | 22 No |
Post New Answer View All Answers
What is Sikuli?
Tell me what kind of tests should not be automated?
What all things can you automate?
Where you have applied oops in automation framework?
what r the diffence between QTP 8.2 & QTP9.0?
How could you explain the main difference between webdriver and rc?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
What is ‘good code’? What is ‘good design’?
write a programme to insert into elements in array?n finding duplicate characters in given sting?
Can you tell some good coding practices while automation?
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
What is test tool?
Can you explain me what is object repository?
Stop automating the tests which run once?
List down the primary features of a good automation tool?