目前我查出來的資料是這樣的
如何實作這種？
大佬快來，謝謝大佬~
uj5u.com熱心網友回復：
第一張圖發錯了，重發第一張圖，并且附SQL
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
uj5u.com熱心網友回復：
rank() over()轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/74943.html
標籤：高級技術
上一篇：關于64位odbc問題