ORACLE常用分析函数

按名字 分组 按日期排序累加

SELECT rs.name,rs.hidate,rs.sal

,SUM(rs.sal) OVER(PARTITION BY rs.name ORDER BY rs.hidate)

  FROM test_１ rs

分组的第一行到该分组最后一行

SELECT rs.name,rs.hidate,rs.sal

,SUM(rs.sal) OVER(PARTITION BY rs.name ORDER BY rs.hidate  

ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED following )

  FROM test_１ rs

分组的第一行到本行

SELECT rs.name,rs.hidate,rs.sal

,SUM(rs.sal) OVER(PARTITION BY rs.name ORDER BY rs.hidate

ROWS BETWEEN  UNBOUNDED PRECEDING  AND CURRENT ROW) 

  FROM test_１ rs

分组的第一行到本行前一行

SELECT rs.name,rs.hidate,rs.sal

,SUM(rs.sal) OVER(PARTITION BY rs.name ORDER BY rs.hidate

ROWS BETWEEN  UNBOUNDED PRECEDING  AND 1  preceding)

 FROM test_１ rs

分组的第一行到本行后一行（最后一行与倒数第二行一样）

SELECT rs.name,rs.hidate,rs.sal

,SUM(rs.sal) OVER(PARTITION BY rs.name ORDER BY rs.hidate

ROWS BETWEEN  UNBOUNDED PRECEDING  AND 1 following)

FROM test_１ rs