title: SQL select a column value that is not zero and if there are multiple values to select the last one
body: <p>I have a table with two columns called NAME and NUMB.  </p>
  
  <pre><code>NAME   NUMB
  John   0
  Sam    0
  Tom    1
  Bob    0
  Tom    0
  Ryu    2
  Ken    0
  </code></pre>
  
  <p>I would like to use some SQL to select that <strong>last</strong> number in that table that isn't a zero.  So my results should show up as "2".  If the 2 was a zero then my results would be "1".  What would be the best way.  Thanks!</p>