working on some analytical function....
with this simple one...
select
keep (dense_rank first order by sum(salary) desc)
from employees;
I am getting a ora-00907 error.
Textbook I'm using is a 9i/10 version, i don't know of any updates that may have affected this syntax but this is a rudimentary version of the textbook example.
Any tips on fixing this?