partition oracle用法,Oracle partition by 使用说明
--用法详解0、select * from wmg_test; ---测试数据1、select v1,v2,sum(v2) over(order byv2) as sum --按照 v2排序,累计n+n-1+....+1from wmg_test;2、select v1,v2,sum(v2) over(partition by v1order byv2) as sum ...