title: Oracle- Selecting max value in a column with reference to a where clause
body: <p>I have a table <code>t1</code></p>
  
  <pre><code>site| count1 | count2
  aaa | 1100   | 500 
  aaa | 1000   | 400
  bbb | 1500   | 700
  bbb | 1200   | 600
  </code></pre>
  
  <p>I want to get the row with the highest column <code>value(1100)</code> corresponding to the site <code>aaa</code></p>
  
  <p>I am looking for a something like</p>
  
  <pre><code>select max(count1),count2 from t1 where site=aaa
  </code></pre>