Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130557 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
how to test an webbased application?
Can you explain me what is object repository?
Mention a few good practices while performing automation testing.
What is functional and regression testing?
What are the risks associated in automation testing?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
In what condition we cannot use automation testing for agile method ?
What is the difference between continue and next sentence?
Tell me how can the user get a text of a web element?
What is keyword driven automation?
What steps are needed in developing and running a software test?
Tell me what type of scenarios can be automated?
What are the drawbacks of test automation?
Differentiate between hdam and hidam database?
Can you list some other automation testing tools that you are familiar with?
