title: how to display the total sum of all individual dates in Oracle
body: <p>I have a query that should display the total sum of sales of all individual dates,not the separate sales in each day. Below is the query I have tried and I am attaching a sample image of the output that I have gotten from this query. Your help would be appreciated.</p>
  
  <p><a href="https://i.stack.imgur.com/lsLFt.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lsLFt.jpg" alt="sample"></a></p>
  
  <pre><code>SELECT sc_cd,Mon,sum(NET_SAL) SALE
    FROM (SELECT TO_CHAR(to_date(deli_DT),'Mm') mm,
                 sc_cd,
                 TO_CHAR(to_date(deli_DT),'dd-Mon-yy') Mon,
                 sum(sale_net) NET_SAL
            from bill_mas
           where sc_cd not in ('22')
             AND deli_dt BETWEEN '01-aug-15' and '31-aug-15'
             AND CANCL IS NULL
             AND sc_cd='01'
           GROUP BY TO_CHAR(to_date(deli_DT),'Mm'),
                    SC_cd,
                    TO_CHAR(to_date(deli_DT),'dd-Mon-yy'),
                    sale_net)
  ORDER BY 3;
  </code></pre>