title: Oracle SQL Return Single Row Based On Max Value of a Column
body: <p>I have in my database table</p>
  <blockquote>
  <p>a | 1</p>
  <p>a | 2</p>
  <p>a | 3</p>
  <p>a | 4</p>
  </blockquote>
  <p>How should I return only with a SELECT query:</p>
  <blockquote>
  <p>a | 4</p>
  </blockquote>
  <p>I have tried several combination with distinct and max values but all seem to be irrelevant.</p>