Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128305 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
Tell me what is the purpose of getoptions() method?
Why do you want to keep this kind of information in a separate file and not directly in the code?
What is the purpose of the wrun.ini file?
What are the steps involved in the automation process ?
What is the deference between automation tools and management tools?
Tell us how do you get the width of the textbox?
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
Please explain what is the hybrid framework?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
List of Test Management Tools??Is Quality Center Test Management tools
Explain what is a relative xpath?
How can you create html test report from your test script?
What are the different types of an automation tool that you are aware of?
whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,
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 :-)
