数据分组求和
来源:互联网 发布:3dsmax绘图软件 编辑:程序博客网 时间:2024/04/27 14:29
-- 分组在求和 count_tb 表的别名
select count(*) from (
SELECT
COUNT(de.CM_ID) as cm_id_count
FROM
do_deliveryorderline de
LEFT join
do_deliveryorderheader d on
de.doh_id= d.doh_id
LEFT join im_item i on
de.im_id=i.IM_ID
WHERE
d.WH_CODE_ORIGIN ='EEUDCA'
and d.DS_CODE='R'
group by i.IM_CODE) count_tb;
SELECT
i.IM_BARCODE as imBarcode,
sum(d.TOTAL_QUANTITY) as receivedQuantity
FROM
do_deliveryorderline de
LEFT join do_deliveryorderheader d on de.doh_id= d.doh_id
LEFT join im_item i on de.im_id=i.IM_ID
WHERE
d.WH_CODE_ORIGIN = 'EEUDCA'
and d.DS_CODE='R'
group by i.IM_CODE
order by receivedQuantity desc
select count(*) from (
SELECT
COUNT(de.CM_ID) as cm_id_count
FROM
do_deliveryorderline de
LEFT join
do_deliveryorderheader d on
de.doh_id= d.doh_id
LEFT join im_item i on
de.im_id=i.IM_ID
WHERE
d.WH_CODE_ORIGIN ='EEUDCA'
and d.DS_CODE='R'
group by i.IM_CODE) count_tb;
SELECT
i.IM_BARCODE as imBarcode,
sum(d.TOTAL_QUANTITY) as receivedQuantity
FROM
do_deliveryorderline de
LEFT join do_deliveryorderheader d on de.doh_id= d.doh_id
LEFT join im_item i on de.im_id=i.IM_ID
WHERE
d.WH_CODE_ORIGIN = 'EEUDCA'
and d.DS_CODE='R'
group by i.IM_CODE
order by receivedQuantity desc
0 0
- 数据分组求和
- 解决问题之道--使用Java实现数据的分组求和
- mysql查询数据时,按照时间分组求和
- cxGrid分组求和设置
- 字符串分组求和
- Sql 分组求和
- DataTable分组求和
- 数据库分组求和问题
- oracle 分组后,求和
- SQL SERVER 分组求和
- List分组求和
- php7中使用mongoDB的聚合操作对数据进行分组求和统计操作
- 对后台返回的json数据按月份分组并求和展示
- Hibernate HQL 分组求和查询
- 分组报表横向扩展求和
- C# List中分组求和
- MySQL按时间分组求和
- Stream流分组,统计,求和
- Maven中dependencyManagement和dependencies的作用和联系
- springAOP之framework包的解读(一)
- dumpmonn twriter
- C++知识碎片整理(9)——Vector&List
- VS2013下OpenCV2.48配置
- 数据分组求和
- 经典排序算法原理及稳定性判断
- JavaScript笔记:表单脚本
- Android中的ToggleButton和Switch开关控件
- 块级元素和行内元素、边距问题
- android打包so文件到apk
- Linux内核目录结构及作用
- 索引,索引的优缺点,普通索引,唯一索引,主键索引,联合主键,复合主键---数据库中的几个概念的理解。
- PHP非递归实现无限级分类