Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128614 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / muralidhara(minchu)
Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);
Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal
| Is This Answer Correct ? | 13 Yes | 22 No |
Post New Answer View All Answers
Can you explain me what is object repository?
What is the difference between automation tools and management tools?
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
What are the pre-requisites to start automation testing?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
What are the different types of locks in mainframe?
Name some of the commonly used automation testing tools that are used for non-functional automation.
what are the questions that are generally asked in an interview if a person is having 3-4 years of exp..and in ds exp 2 yrs exp is wd automation testing
What is junit? And what is junit annotation?
Tell me the fundamental difference between xpath and css selector?
Do you know the difference between close and quit command?
what r the diffence between QTP 8.2 & QTP9.0?
What is in-house tool?
Explain load testing on websites?
Once you identify the tool what would be your next steps?
