declare department_cursor cursor for
select distinct Fdept from yourDept
open department_cursor
fecth next from department_cursor into @dept
while(fecth_status=0)
begin
insert into @SalaryTable select top 3 Fname,Fsalary,Fdept from yourDept where Fdept=@dept order by Fsalary DESC
fecth next from department_cursor into @dept
end
select * from @SalaryTable
close department_cursor
dealloate department_cursor