随笔分类 -  Oracle

摘要：统计求和：分组求和：sum(字段) over(patition by 字段)连续求和：sum(字段) over(order by 字段)分组排序编号：row_number(字段) over(partition by 字段, order by 字段)分组合计：group by ROLLUP(字段)递归... 阅读全文