title: MAX on two columns in mysql
body: <p>I wonder if there is better way to get max from column c1 and then max from column c2 for selected rows than  </p>
  
  <pre><code>SELECT MAX(c1) , MAX(c2) FROM t GROUP BY c1 HAVING c1 = MAX(c1)
  </code></pre>