举例说明:
员工每个月都会有薪水,需要查出每个月的薪水以及累计薪水,可以用下面SQL语句查询:
SELECT MONTH, SALARY, SUM(SALARY) OVER(ORDER BY MONTH ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) SUM_SALARY FROM USER_SALARY
举例说明:
员工每个月都会有薪水,需要查出每个月的薪水以及累计薪水,可以用下面SQL语句查询:
SELECT MONTH, SALARY, SUM(SALARY) OVER(ORDER BY MONTH ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) SUM_SALARY FROM USER_SALARY
下一篇:程序员面试建议
java stream 某个字段去重排序
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M