Write a query to find second highest salary of an employee.

Answers were Sorted based on User's Feedback



Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

Answer / lia

select employee_name
from employee
order by salary desc
where ROWNUM=2

Is This Answer Correct ?    31 Yes 83 No

Post New Answer

More Automation Testing AllOther Interview Questions

in my application i am getting different errors at same place. how i capture that errors using less code in qtp.

1 Answers   CTS,


which is the best online training website?

0 Answers  


What are the disadvantages of Hybrid framework

0 Answers  


1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: “test scenarios” & “test approch”: points)

0 Answers  


why we cannot apply check points in compile modules?

0 Answers  






What skills needed to be a good test automator?

1 Answers  


how can we exactly identity whether that is manual or automation testing? and give any ex script

1 Answers   JVS,


Hi, Can anyone please tell me which Test Automation tool can be used for : 1. Web based testing 2. .Net (C#) applications 3. Mobile applications (PDA)

1 Answers  


Hi friends please tell me regardinr to QTP descriptive programming. if any materials are there suggest me. or if you have please give me. thank u waiting for reply

1 Answers  


Describe some problem that you had with automating testing tool.

1 Answers  


What are the limitations of automating software testing?

1 Answers  


What is the purpose of the wrun.ini file?

0 Answers  


Categories