Write a query to find second highest salary of an employee.
Answer Posted / murlidhar
select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)
| Is This Answer Correct ? | 41 Yes | 36 No |
Post New Answer View All Answers
Tell us what methods of robot class do you know?
How do select which automation testing tool is the best for you?
Is automation testing in agile methodology useful or not?
Do you know what is selenese?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
What are different coverages in function testing?
Do you know what is a data-driven framework?
Why do you prefer selenium automation tool?
What do you think holds testers back to do automation? Is there a way to overcome it?
Tell me what is regression testing?
what are the steps followed in unit testing, system testing, integration testing
What u mean by infrgistics control (What is infrgistics Controls)?
We have a testing assignment that is time-driven. Do you think automated tests are the best solution?
what are the questions that are generally asked in an interview if a person is having 3-4 years of exp..and in ds exp 2 yrs exp is wd automation testing
Explain about basics of rational robot - ibm test automation tool?