title: SQL select to display latest record
body: <p>So here is a case where one of the column in a table has same values for multiple records but the <code>Date</code> column has incremental values. </p>
  
  <pre><code>ID| PAY_CODE| RATE  |   Date
  ---------------------------------
  1 |  1111   |  50   | 2017-01-01
  2 |  1111   |  50   | 2017-02-01
  3 |  1111   |  50   | 2017-03-11
  4 |  1111   |  50   | 2017-05-21
  </code></pre>
  
  <p>How can I print only the latest record if the latest <code>Date</code> entered is unknown?</p>
  
  <p>Expected result:</p>
  
  <pre><code>ID| PAY_CODE| RATE  |   Date
  ---------------------------------
  4 |  1111   |  50   | 2017-05-21
  </code></pre>
  
  <p>I need a SQL query which internally compares the <code>Date</code> column and returns the highest value (Latest date in this case) - is  this even possible?</p>