title: Get only 1 row with MAX() in colums - SAP HANA
body: <p>I've this table:</p>
  
  <pre><code>|--------------|-------------|-----------|-----------|
  |    cli_id    |    email    |   is_one  |  n_order  |
  |--------------|-------------|-----------|-----------|
  |       1      |   a@a.com   |     1     |   2341    |
  |--------------|-------------|-----------|-----------|
  |       1      |   b@a.com   |     0     |     21    |
  |--------------|-------------|-----------|-----------|
  |       1      |   c@a.com   |     0     |    121    |
  |--------------|-------------|-----------|-----------|
  |       1      |   a@a.com   |     1     |     50    |
  |--------------|-------------|-----------|-----------|
  </code></pre>
  
  <p>How can I select only 1 email, the one with MAX(is_one) and MAX(n_order)?   For example, I cannot use "WHERE is_one = 1", I must use "max(is_one)" or equivalent.</p>
  
  <p>The result must be this one:</p>
  
  <pre><code>|-------------|
  |    email    |
  |-------------|
  |   a@a.com   |
  |-------------|
  </code></pre>
  
  <p>Thanks!</p>