Write a query to find second highest salary of an employee.
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
What are the important operations in database testing?
What kinds of annotations are used in testng?
wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
Why do you want to keep this kind of information in a separate file and not directly in the code?
Explain about basics of rational robot - ibm test automation tool?
What u mean by infrgistics control (What is infrgistics Controls)?
Bug report formate in bugzilla
Name some of the commonly used automation testing tools that are used for non-functional automation.
how can i count the no of edit field in a page and fill the multiple edit field
What are the 5 common software development problems solutions?
How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.
is anybody suggest me which one is the best testing institute in ameerpet hydrabad
hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help
How do we Test the C++ and Unix Application Using Automated Tool.