ITPub博客

行列转换例子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

.....[@more@]因为悔恨所以才是人生吗?哭过、笑过、坚强过、懦弱过、上进过、堕落过、诚实过、撒谎过、庆幸过、后悔过、成功过、失败过....人啊，都不容易...