給你參考
很像 你可以改成你要的
你有更難的 更酷的 可以提出來

ERP 技術轉移顧問
Oracle PL/SQL 20年經驗給你參考

SELECT
(SELECT MAX(xvl.PriceActual)||' - '||MIN(xvl.PriceActual)
FROM C_InvoiceLine xvl, C_Invoice xiv, M_Product xpd
WHERE xiv.C_Invoice_ID=xvl.C_Invoice_ID
AND xpd.M_Product_ID=xvl.M_Product_ID
AND TRUNC(xiv.DateInvoiced,'MM')=ADD_MONTHS(TRUNC(SYSDATE,'MM'),-2)
AND xvl.M_Product_ID=vl.M_Product_ID) AS PriceActualX,

pd.Name,pd.Value,iv.DateInvoiced, vl.PriceActual

FROM C_InvoiceLine vl, C_Invoice iv, M_Product pd
WHERE iv.C_Invoice_ID=vl.C_Invoice_ID
AND pd.M_Product_ID=vl.M_Product_ID
AND TRUNC(iv.DateInvoiced,'MM')=ADD_MONTHS(TRUNC(SYSDATE,'MM'),-2)

AND
(
vl.PriceActual <>
(SELECT MAX(xvl.PriceActual)
FROM C_InvoiceLine xvl, C_Invoice xiv, M_Product xpd
WHERE xiv.C_Invoice_ID=xvl.C_Invoice_ID
AND xpd.M_Product_ID=xvl.M_Product_ID
AND TRUNC(xiv.DateInvoiced,'MM')=ADD_MONTHS(TRUNC(SYSDATE,'MM'),-2)
AND xvl.M_Product_ID=vl.M_Product_ID)

OR
vl.PriceActual <>
(SELECT MIN(xvl.PriceActual)
FROM C_InvoiceLine xvl, C_Invoice xiv, M_Product xpd
WHERE xiv.C_Invoice_ID=xvl.C_Invoice_ID
AND xpd.M_Product_ID=xvl.M_Product_ID
AND TRUNC(xiv.DateInvoiced,'MM')=ADD_MONTHS(TRUNC(SYSDATE,'MM'),-2)
AND xvl.M_Product_ID=vl.M_Product_ID)
)

ORDER BY pd.Name,pd.Value,vl.PriceActual

SELECT 廠區,料號,單價,SUM(數量) , MAX(採購日期)
FROM TABLE_NAME
GROUP BY 廠區,料號,單價