title: Select row only on a max field
body: <pre><code>id  name    school  date
  1   John    QVS 1/3/2000
  1   John    RKS 1/4/2008
  2   Sera    ACS 1/2/2009
  2   Sera    WCS 1/4/2011
  3   Jack    YUN 1/4/2014
  3   Jack    KIL 1/3/2017
  </code></pre>
  
  <p>The name, school and date all came from different tables namely, name, school and date joined together with inner join.</p>
  
  <p>i want to select only the row with the latest date. The result should be:</p>
  
  <pre><code>id  name    school  date
  1   John    RKS 1/4/2008
  2   Sera    WCS 1/4/2011
  3   Jack    KIL 1/3/2017
  </code></pre>