Friday, 27 September 2013

SQL SUM not SUM all column but show all data

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