Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126077 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / shyam
select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the process of Automation Testing?
What are the different types of scripting techniques for automation testing?
how can i count the no of edit field in a page and fill the multiple edit field
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
What are the points that are covered while planning phase of automation ?
i need test cases for defect maganement tools
Tell me an example of the languages supported by webdriver?
what is the advantage and dis-advantages of using framework ?
What is the purpose of deselectall() method?
What is the purpose of the wrun.ini file?
Do you know how to verify if the checkbox/radio is checked or not?
What are the advantages of the automation framework?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
what is GDC
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... :(
