Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128255 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
How many test cases have you automated per day?
suggest me the free online books on software testing?
How would you test your own element locator?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?
write a programme to insert into elements in array?n finding duplicate characters in given sting?
how can i count the no of edit field in a page and fill the multiple edit field
What are the points that are covered while planning phase of automation ?
Is automation testing a black box testing or white-box testing?
What is Sikuli?
What are Keyword and Data driven frameworks in Selenium RC
What generally is the structure of a framework?
Tell me how could ajax controls be handled in webdriver?
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
