title: How to find Max value of an alphanumeric field in oracle?
body: <p>I have the data as below and ID is VARCHAR2 type</p>
  
  <p><strong>Table Name :EMP</strong></p>
  
  <pre><code>ID    TST_DATE
  A035     05/12/2015
  BAB0     05/12/2015
  701    07/12/2015
  81     07/12/2015
  </code></pre>
  
  <p>I used below query to get max of ID group by TST_DATE.</p>
  
  <pre><code>SELECT TST_DATE,MAX(ID) from EMP group by TST_DATE;
  
  TST_DATE     MAX(ID)
  05/12/2015    BAB0 
  07/12/2015    81
  </code></pre>
  
  <p>In the second row it returning 81 instead of 701.</p>