Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130604 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / hardit
select TOP 1[salary]
from(
select distinct TOP 2[salary]
from empTable
order by salary desc
) a
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what is the purpose of deselectall() method?
What are the most popular tools for automation testing?
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
Do you think that testing can be done only at the ui level?
What are the differences between open source tools, vendor tools, and in-house tools?
When is automation testing useful?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
How you report bug in to bugzilla
Tell us what you know about table-driven testing?
Please name a couple of standard web function found in the function generator?
how to use regular expression in Test Complete Functional tool
Do you know the difference between close and quit command?
What is test tool?
What is test driven development?
Explain me which web driver implementation is the fastest?
