Write a query to find second highest salary of an employee.
Answer Posted / girase hitendrasing a.
select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
4. How we implement Winrunner,in our project?
List the five essential types of test steps?
What is a framework and what are the frameworks available in rc?
Can the activities of test case design be automated?
Can you tell some good coding practices while automation?
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
Tell us how could you explain the main difference between webdriver and rc?
Does automation testing have any disadvantages?
what are the steps followed in unit testing, system testing, integration testing
Do you know what is the difference between "type" and "typeandwait" command?
How can you switch back from a frame?
What are Keyword and Data driven frameworks in Selenium RC
Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?
Elaborate the scripting standard while executing testing
explain add in manager and virtual object wizard in winrunner