title: mysql - Get two greatest values from multiple columns
body: <p>We can use <a href="http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#function_greatest">GREATEST</a> to get greatest value from multiple columns like below</p>
  
  <pre><code>SELECT GREATEST(mark1,mark2,mark3,mark4,mark5) AS best_mark FROM marks
  </code></pre>
  
  <p>But now I want to get two best marks from all(5) marks.</p>
  
  <p>Can I do this on mysql query?</p>
  
  <p>Table structure (I know it is wrong - created by someone): </p>
  
  <pre><code>student_id  | Name | mark1 | mark2 | mark3 | mark4 | mark5
  </code></pre>