select * from (select sum(dpt_no) as numbers from department group by dpt_name) order by numbers desc
Результат:
NUMBERS
----------
420
209
106
105
103
102
Как присвоить ранги этому результату?
Пожалуйста попробуйте:
select
numbers,
rank() over(order by numbers desc) Rank
from (
select sum(dpt_no) as numbers
from department group by dpt_name
)
order by numbers desc
образец:
select
Col,
rank() over(order by Col desc) Rank
From YourTable
