Hi All,

Can anybody tell me what will be the SQL Query for finding the employee
with second highest salaray in the company. There may be several employees.
ur help will be of gr8 help

Regards

select top 1 with TIES (salary) from employees e1
where salary < (select Max (salary) from employees)
order by salary desc

M

Or....

declare @employees table (
employee int identity(1,1) not null,
salary money
)

insert into @employees
select 100 union all
select 150 union all
select 200


Select Top 1 s1.employee, s1.salary from (
Select Top 2 employee, salary from @employees order by salary desc
) s1
order by s1.salary


[quoted text, click to view]