Write a query to find second highest salary of an employee.
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 which web driver implementation is the fastest?
Tell me how would you test your own element locator?
4. How we implement Winrunner,in our project?
Tell me what is intellij?
what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please
Tell us what is the alternate way to click on login button?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
How can you switch back from a frame?
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
List of Test Management Tools??Is Quality Center Test Management tools
Do you know what is the purpose of deselectall() method?
What is the purpose of deselectall() method?
What type of scenarios can be automated?
Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..