title: How to get max date value in each individual employee?
body: <p>I tired to this query please help me.</p>
  
  <pre><code>select max(cr.`CARD_RECHARGE_ID`),cp.`FULL_NAME` as userName , cr.`CHARGE_DATE` as lastRechargeDate,cr.`CUSTOMER_ID`
  from nettxs_communication.customerprofile cp
  LEFT JOIN nettxs_communication.cardrecharge cr ON cr.`CUSTOMER_ID` = cp.`CUSTOMER_ID` 
  group by cr.`CUSTOMER_ID` ORDER BY cr.`CHARGE_DATE`;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/sj3Z0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sj3Z0.jpg" alt="enter image description here"></a></p>