SUM OVER PARTITION BY ORDER BY(分组累计计算方法)
来源:互联网 发布:广电网络设备有哪些 编辑:程序博客网 时间:2024/05/30 04:38
仅限SQL SERVER2012以上版本
create table TEST(ID int identity(1,1),NAME NVARCHAR(50),GROUPNAME NVARCHAR(50),GRADE INT,DIRECTION INT)DROP TABLE TESTINSERT INTO TEST(NAME,GROUPNAME,GRADE,DIRECTION)SELECT '小明','开发部',90,-1 UNION ALLSELECT '小张','开发部',89,+1 UNION ALLSELECT '小白','开发部',100,-1 UNION ALLSELECT '小王','财务部',70,-1 UNION ALLSELECT '小赵','财务部',69,+1 UNION ALLSELECT '小柳','财务部',90,+1 UNION ALLSELECT '小高','行政部',78,-1 UNION ALLSELECT '小王','行政部',77,+1 UNION ALLSELECT '小李','行政部',99,-1 UNION ALLSELECT '小吴','行政部',34,-1SELECT * FROM TESTSELECT ID, NAME, GROUPNAME, GRADE, DIRECTION, SUM(GRADE*DIRECTION) OVER(PARTITION BY GROUPNAME ORDER BY ID) AS ACCUMULATIONFROM TEST
阅读全文
0 0
- SUM OVER PARTITION BY ORDER BY(分组累计计算方法)
- row_number() over(partition by '分组' order by '日期')
- row_number() over (partition by..order by...)分组排序
- over(partition by ...order by ...)
- sum(col1) over(partition by col2 order by col3 )
- sum(x) over( partition by y ORDER BY z ) 分析
- sum(x) over( partition by y ORDER BY z ) 分析
- Oracle之sum / over / partition by / order by联合使用
- OVER(PARTITION BY OVER (ORDER BY
- oracle分析函数系列之sum(col1) over(partition by col2 order by col3):实现分组汇总或递增汇总
- oracle分析函数系列之sum(col1) over(partition by col2 order by col3):实现分组汇总或递增汇总 .
- oracle分析函数系列之sum(col1) over(partition by col2 order by col3):实现分组汇总或递增汇总
- [整理]rank over (partition by ... order by ...)
- ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...)
- row_number() over (partition by....order by...)用法
- row_number() over (partition by....order by...)用法
- row_number() over (partition by....order by...)用法
- Oracle over(partition by ...order by ...)
- eclipse:自动调整代码格式
- 趣店能否撑起百亿美元市值!
- 二级列表购物车
- jemeter之性能测试
- 【ES6】const命令和import命令
- SUM OVER PARTITION BY ORDER BY(分组累计计算方法)
- IO流
- thymeleaf项目路径
- LeetCode 24. Swap Nodes in Pairs
- //BottomTabBar实现底部选项卡
- 原生选择第一个元素
- listview多条目 GridView TabLayout pullToRefresh radioGroup +fragment
- 图片的二次采样Bitmap
- C++虚函数