Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128823 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / jawad humayun
SELECT MIN(salary)
FROM employ
WHERE salary IN (SELECT salary
FROM employ
ORDER BY salary DESC
LIMIT 2)
This querry will give the 2nd highest salary
to have nth highest salary replace 'LIMIT 2' by 'LIMIT n'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Tell us what is junit? And what is junit annotation?
Tell me what is an absolute xpath?
What type of scenarios can be automated?
Explain me how to check if an element is visible on the page?
how to know whether the user information or any other information which is entered in to the web is storing in secured place or non secured place?
Tell us can we find all links on a web page?
Tell me what is a keyword-driven framework?
What are the risks associated in automation testing?
Name the frameworks that are used in software automation testing?
what is critical test case ? please give an 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... :(
Is ui level testing possible?
Is automation testing in agile methodology useful or not?
What is junit annotation?
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)
