-
编辑 删除
列行转换例子
行列转换例子select max(count(*)) from employees a group by a.job_id,a.manager_id--6select o.job_id, o.manager_id, max(decode(o.px, 1, o.last_name, null)) name1, max(decode(o.px, 1, o.salary, null)) salart1, max(decode(o.px, 2, o.last_name, null)) name2, max(decode(o.px, 2, o.salary, null)) salart2, max(decode(o.px, 3, o.last_name, null)) name3, max(decode(o.px, 3, o.salary, null)) salart3, max(decode(o.px, 4, o.last_name, null)) name4, max(de
-
编辑 删除
行列转换例子
行列转换例子select max(count(*)) from employees a group by a.job_id,a.manager_id--6select o.job_id, o.manager_id, max(decode(o.px, 1, o.last_name, null)) name1, max(decode(o.px, 1, o.salary, null)) salart1, max(decode(o.px, 2, o.last_name, null)) name2, max(decode(o.px, 2, o.salary, null)) salart2, max(decode(o.px, 3, o.last_name, null)) name3, max(decode(o.px, 3, o.salary, null)) salart3, max(decode(o.px, 4, o.last_name, null)) name4, max(de
