SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select nvl(to_char(manager_id), '') as manager_id, nvl(job_id, '') as job_id, sum(salary) as salary from employees where manager_id < 120 group by rollup(manager_id, job_id) order by manager_id, case when job_id is null then 1 else 0 end, salary desc;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear