title: SQL Find MAX Values for multiple rows
body: <p>Data Set </p>
  
  <pre class="lang-none prettyprint-override"><code>Name    Number  Value
  Alabama  254    100
  Atlas    156    200
  Alabama  354    300
  Atlas    800    400
  </code></pre>
  
  <p>SQL Statement as to return the Max Number per Name. </p>
  
  <p>desired outcome </p>
  
  <pre class="lang-none prettyprint-override"><code>Alabama  354    300
  Atlas    800    400
  </code></pre>