SQL SUM not SUM all column but show all data
How to SUM all of my column in my table with database oracle ? The SQL
code like this :
SELECT DISTINCT
M.MODEL_NO,
P.FORM_NO,
P.MODEL_NO,
TO_CHAR(TO_DATE(P.DATE_ADDED,'YYYY-MM-DD'),'MONTH'),
Q.FORM_NO,
Q.STATUS_QTY,
SUM(Q.QTY) OVER (PARTITION BY P.FORM_NO ORDER BY P.FORM_NO
RANGE UNBOUNDED PRECEDING) QTY
FROM
SEIAPPS_MODEL M, SEIAPPS_PRODUCTION_STATUS P, SEIAPPS_QTY Q
WHERE
P.FORM_NO = Q.FORM_NO AND P.MODEL_NO = M.MODEL_NO AND M.MODEL_NO = '15'
AND P.DATE_ADDED LIKE '2013-05%' AND Q.STATUS_QTY = 'OK';
When I query this SQL code in TOAD, it will show all data, not SUM for all.
What I wanted is like this :
SUM_ALL
5000 (example value)
Please advice. Thanks
No comments:
Post a Comment