title: How to get the max timestamp row from a given table
body: <p>I am trying to get the max timestamp rows based of a group of <code>software_image_build_id and variant</code></p>
  
  <p>Here is my SQL fiddle link <a href="http://sqlfiddle.com/#!9/6ed643/1" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/6ed643/1</a> ,it should output the max timestamp rows for a combination for software_image_build_id and variant  ,I tried as follows but it is not helping,can anyone provide guidance on how to fix it?</p>
  
  <pre><code>SELECT software_image_build,MAX(timestamp) FROM software_image_builds where software_image_id=1452
  group by software_image_build
  </code></pre>