Write a query to find second highest salary of an employee.
- 72 Answers
- 109302 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / mitul deshmukh
Select Salary
from Employee emp
where
2 = Select Count(Salary) from Employee emp1
Where
emp.Salary >= em1.Salary))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the phases in automation testing life cycle?
What kind of tests should not be automated?
How could you explain the main difference between webdriver and rc?
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What you know about table-driven testing?
Once you identify the tool what would be your next steps?
What issues come up in test automation, and how do you manage them?
What is the deference between automation tools and management tools?
What is modular automation?
What is ‘good code’? What is ‘good design’?
What is open source tool and give example?
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
Tell us how could you explain the main difference between webdriver and rc?
I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.
What is test tool?
