Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126075 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 |
What automated tools are you familiar with?
Any kind of test which you think should not be automated?
How did you use automating testing tools in your job?
what is GDC
Tell us how can you create html test report from your test script?
What is Automation Testing Framework
Explain me what is testng and why is it better than junit?
How you report bug in to bugzilla
I am looking for selenium RC Training in Hyderabad. can any one tell me the best institute ?
how many steps in functional testing?
Why do you want to keep this kind of information in a separate file and not directly in the code?
When is automation testing useful?
WinRunner 
