title: SQL Unable to filter for a specific date with Group By
body: <p>This might be something simple but I cannot get the desired output.</p>
  <p>I am using this simple query below to get the latest <code>exp_date</code> of an <code>item_no</code></p>
  <pre><code>select g.item_no,max(g.exp_date)
  from grn_drug_item g
  group by g.item_no
  </code></pre>
  <p>1st query only displays following result for <code>01-AUG-20</code></p>
  <pre><code>IT00002530 01-AUG-20
  </code></pre>
  <p>Now I want to filter above results for a 'specific' latest <code>exp_date</code> (ex: <code>01-AUG-20</code> as above) so I modified the query to:</p>
  <pre><code>select g.item_no,max(g.exp_date)
  from grn_drug_item g
  where g.exp_date = to_date('01-AUG-20','DD-MON-YY')
  group by g.item_no
  </code></pre>
  <p>But this gives me multiple rows and if I use <code>where g.item_no = 'IT00002530'</code> it fetches the desired output.</p>
  <p>How can I get the filtering working for a specific <code>exp_date</code> here?</p>