About Rank Function?

[#1]

Hi Folks,

I have a Table with Emp_ID,Sal,Deptno

I want to show only top 10 Salaries Deptno or Emp_ID

I tried Rank(sum(Sal),10) --It is not giving the proper result what i expect.

Can u plz suggest me this using Rank function only.

I tried aggr(rank(sum(Sal))<10,Deptno) --- both are not working properly.

Thanks,

rakesh

[MarcoWedel]

why?