新人求助 oracle分组统计问题 目前我查出来的数据是这样的如何实现这种?大佬快来,谢谢大佬~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 第一张图发错了,重发第一张图,并且附SQLSQL:SELECT GROUP_NAME, DOC_DATE, DOC_ID, PRODUCT_ID, PRODUCT_NAME, SUM(QUANTITY) AS QUANTITY, DWFROM ( SELECT RD.DOC_ID, RI.FACILITY_ID, RI.PRODUCT_ID, PRO.PRODUCT_NAME, RI.PRICE, RI.QUANTITY * DECODE ( RI.UNIT_QUANTITY, NULL, 1, 0, 1, RI.UNIT_QUANTITY ) AS QUANTITY, RD.DOC_DATE, RC.VENDOR_ID, PG.GROUP_NAME, SBT.DESCRIPTION AS DW FROM RECEIVE_DOC RD INNER JOIN RECEIVE_ITEM RI ON RD.DOC_ID = RI.DOC_ID INNER JOIN RECEIVE_COMMAND RC ON RD.BASE_ENTRY = RC.DOC_ID LEFT JOIN PRODUCT PRO ON RI.PRODUCT_ID = PRO.PRODUCT_ID LEFT JOIN SHIPMENT_BOX_TYPE SBT ON PRO.DEFAULT_SHIPMENT_BOX_TYPE_ID = SBT.SHIPMENT_BOX_TYPE_ID LEFT JOIN PARTY_GROUP PG ON PG.PARTY_ID = RC.VENDOR_ID WHERE 1 = 1 AND RD.MOVEMENT_TYPE_ID = 'IC' )GROUP BY GROUP_NAME, DOC_DATE, DOC_ID, PRODUCT_ID, PRODUCT_NAME, DW rank() over() oracle的基本问题,着急。来看 3个表做关联,其中一个表的关联字段可能为空。要求为空时输出空,怎么写? 关于oracle procedure 的exec 参数问题 ADO访问ORACLE数据库的运行环境 谁有没有ORACLE软件给我一个 oracle乱码问题 请问大家,一般大的文本大家都用什么方式存储,怎么获取该文本,该文本怎么插入 关于sql语句影响的行数问题 谁给推荐几本好的学习oracle的书!!!!!!!!! orcal update问题 instr 优化方法forall? 数据层级统计问题,各位大神 ~~~~
SQL:
SELECT
GROUP_NAME,
DOC_DATE,
DOC_ID,
PRODUCT_ID,
PRODUCT_NAME,
SUM(QUANTITY) AS QUANTITY,
DW
FROM
(
SELECT
RD.DOC_ID,
RI.FACILITY_ID,
RI.PRODUCT_ID,
PRO.PRODUCT_NAME,
RI.PRICE,
RI.QUANTITY * DECODE (
RI.UNIT_QUANTITY,
NULL,
1,
0,
1,
RI.UNIT_QUANTITY
) AS QUANTITY,
RD.DOC_DATE,
RC.VENDOR_ID,
PG.GROUP_NAME,
SBT.DESCRIPTION AS DW
FROM
RECEIVE_DOC RD
INNER JOIN RECEIVE_ITEM RI ON RD.DOC_ID = RI.DOC_ID
INNER JOIN RECEIVE_COMMAND RC ON RD.BASE_ENTRY = RC.DOC_ID
LEFT JOIN PRODUCT PRO ON RI.PRODUCT_ID = PRO.PRODUCT_ID
LEFT JOIN SHIPMENT_BOX_TYPE SBT ON PRO.DEFAULT_SHIPMENT_BOX_TYPE_ID = SBT.SHIPMENT_BOX_TYPE_ID
LEFT JOIN PARTY_GROUP PG ON PG.PARTY_ID = RC.VENDOR_ID
WHERE
1 = 1
AND RD.MOVEMENT_TYPE_ID = 'IC'
)
GROUP BY
GROUP_NAME,
DOC_DATE,
DOC_ID,
PRODUCT_ID,
PRODUCT_NAME,
DW