Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128359 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / sridhar
Its real simple. Suppose your employees are in a table
called by the same name, and the salaries in a column named
salaries). Lets See te case in which we want the 3 greatest
salaries. Then you Query:
SELECT employees.salary
FROM employees
ORDER BY employees.salary desc
LIMIT 3;
If you want the biggest 5 salaries, you put LIMIT 5, and so on….
| Is This Answer Correct ? | 3 Yes | 16 No |
Post New Answer View All Answers
Tell me what kind of tests should not be automated?
how to re-install QTP 11.0 trial version
Mention a few good practices while performing automation testing.
1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)
What is client side validation? Write a snippet.
What are the phases in automation testing life cycle?
5. What are the tests you are conducting through winrunner?
Give some examples of priority – severity defect levels.
22. Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.
you have same applications (same server configaration)A&B you are doing nonfunctionality testing . what they differ in?
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
What are the different types of an automation tool that you are aware of?
What are the advantages of test automation?
What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.
Tell me what is the testng.xml file used for?
