Swaminathan K
asked on
oracle rollup query
Hi ,
My question might sound easy , but I want to understand why oracle is not generating a grand total when I fire the below query
Select department_id , job_id , count(*)
from employees
group by department_id,rollup(depar tment_id, job_id)
I get the grandtotal with rollup , if i fire the below query
Select department_id , job_id , count(*)
from employees
group by rollup(department_id, job_id)
Any help is really appreciated. The above queries are firedin HR schema.
My question might sound easy , but I want to understand why oracle is not generating a grand total when I fire the below query
Select department_id , job_id , count(*)
from employees
group by department_id,rollup(depar
I get the grandtotal with rollup , if i fire the below query
Select department_id , job_id , count(*)
from employees
group by rollup(department_id, job_id)
Any help is really appreciated. The above queries are firedin HR schema.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
awesome
that has priority over the rollup
that's why you don't get a total