title: How to get the 2 greatest values between multiple columns?
body: <p>I'm trying to figure out how to get the 2 highest values from 5 fields. I know about the <code>greatest</code> function, but I don't know how to pull out the second highest value, too.</p>
  
  <p>Basically, the table has 5 <code>NUMBER</code> type fields. In this example, the last two columns are my desired results.</p>
  
  <pre class="lang-none prettyprint-override"><code>| Score1 | Score2 | Score3 | Score4 | Score5 | | Highest1_value | Highest2_value 
  +--------+--------+--------+--------+--------+ +----------------+---------------
  |    10  |    20  |    30  |    40  |   50   | |       50       |       40
  |    20  |    20  |    12  |    17  |    0   | |       20       |       20
  |     7  |     7  |     7  |     7  |   11.1 | |       11.1     |        7
  |    10  |    10  |    10  |    10  |   10   | |       10       |       10
  </code></pre>