T-SQL or stored procedure to find employees with salary in top 5%

[rupinderbatra]

Hello Everyone,

I have a table with the following structure:

Employee ID, Salary.

I want to find employees with top 5% salaries.

Appreciate if someone may please help.

Thanks,
Rupinder

[azimmer]

Hello Everyone,

I have a table with the following structure:

Employee ID, Salary.

I want to find employees with top 5% salaries.

Appreciate if someone may please help.

Thanks,
Rupinder

select top 5 percent emp_id, salary
from myTable
order by salary desc
 

[rupinderbatra]

select top 5 percent emp_id, salary
from myTable
order by salary desc
 

Thanks for the suggestion but the above query will return top 5 percent rows with salary in descending order. What I am trying to achieve is to have the rows with salary in top 5 percent. for ex: if maximum salary is 100, I want to retrieve all rows with salary >=95.

Thanks,
Rupinder

[azimmer]

Thanks for the suggestion but the above query will return top 5 percent rows with salary in descending order. What I am trying to achieve is to have the rows with salary in top 5 percent. for ex: if maximum salary is 100, I want to retrieve all rows with salary >=95.

Thanks,
Rupinder

OK, that's different:

select empid, salary
from mytable
where salary >= (select 0.95*max(salary) from mytable)
 

[rupinderbatra]

OK, that's different:

select empid, salary
from mytable
where salary >= (select 0.95*max(salary) from mytable)
 

Thanks, it worked.
In my actual problem, I had a table with employee and their scores for various campaigns and I had to find top 5% of the cumulative scores of an employee. So, I used temporary tables and applied your logic on the temporary table to make it work.
Thanks once again,
Rupinder