Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128791 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
Give some examples for test management tools?
What is testng and why is it better than junit?
What are Keyword and Data driven frameworks in Selenium RC
Tell me what databases can test director reside on?
What is meant by the automation framework?
Elaborate the situation where automation testing can’t be used for agile methods?
Tell me what is a keyword-driven framework?
List some advantages and disadvantages of automation testing.
What type of scenarios can be automated?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
how to test an webbased application?
Which protocol cam be used to makw jdbc connection woth loadrunner
What are pros and cons of automating tests at ui layer?
What are the limitations of automating software testing?
