title: How to get current month records from ORACLE since first date.?
body: <p>here is my code</p>
  
  <pre><code>SELECT h.ENTERED_DATE,
         d.DENOMINATION,
         sum(h.invoice_total-h.TOTTAL_DISCOUNT)as amount 
    FROM sales_details d
         LEFT JOIN sales_header h 
              ON d.invoice_id=h.invoice_id
   WHERE entered_by='2254'
  --HERE IS NEED TO GET DETAILS CURRENT MONTH 1st Date to Sysdate 
  GROUP BY 
         ENTERED_DATE,
         d.DENOMINATION
  ORDER BY 
         entered_date,
         denomination
  </code></pre>
  
  <ul>
  <li>In my application just send only <strong>sysdate</strong> as parameter.
  <strong>no need to SYSDATE-30.
  need 1st date to SYSDATE</strong></li>
  </ul>
  
  <p>here shows my two tables
  <strong>sales_header table</strong>
  <img src="https://i.stack.imgur.com/AWcn6.png" alt="enter image description here"></p>
  
  <p><strong>sales_details table</strong>
  <img src="https://i.stack.imgur.com/viDLQ.png" alt="enter image description here"></p>