Write a query to find second highest salary of an employee.
- 72 Answers
- 109502 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajeshraajan
SQL Server ( For 2nd max Salary )
---------------------------------
select Min(salary) from
( Select Top 2 salary from
( Select distint salary from Employee Order by
salary Desc ))
with this query we can find n th salary.
if am wrong plz correct me.
thx
| Is This Answer Correct ? | 53 Yes | 95 No |
Answer / lia
select employee_name
from employee
order by salary desc
where ROWNUM=2
| Is This Answer Correct ? | 31 Yes | 83 No |
How to find that tools work well with your existing system?
wat is difrenc btwn test case and test senario . can anybody know the answer just post it
Tell me what is the purpose of getoptions() method?
how to re-install QTP 11.0 trial version
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
what testing activity you may want to automate?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
Why automation testing?
diff b/w DBMS & RDBMS?
69 Answers BirlaSoft, Infosys, Mind Tree, TCS,
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
what is meant by keyboard driven test?
WinRunner 
