qq_36760847的博客

over(partition by) -- 虚构表数据 select '1' id,'type1' type_name, '1' val from dual union all select '2' id ,'type1' type_name, '2' val from dual union all select '3' id ,'type2' type_name, '1' val from d...

https://blog.youkuaiyun.com/wdwyf999/article/details/86065047

参考资料 https://blog.youkuaiyun.com/uniqueweimeijun/article/details/82668835