Write a query to find second highest salary of an employee.
- 72 Answers
- 109363 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
Explain some disadvantages to manual software testing?
What is open source tool and give example?
Please explain what is the hybrid framework?
What kind of tests would you automate?
Is ui level testing possible?
wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.
Tell us how can you create html test report from your test script?
If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!
What is a ‘test plan’? What is a ‘test case’?
What is client side validation? Write a snippet.
What are different coverages in function testing?
How software testing is handled?
Hi All, Is there any free automation tool for windows application and it's easy to use? I usually take a lot of time to regression test my application when there is a new build on live environments (about same 10 environments) I wish I know a automation tool to regression test and ofcourse it's free, easy to use (maybe using C#) Could anybody can advise to me a tool like that? I very appreciate ^^
Is automation testing a complete replacement for manual software testing?
What is self-referencing constraint in mainframe development?
