title: order by field greater than 0
body: <p>suppose I've these rows in my database : </p>
  
  <pre><code>1
  0
  5
  2
  0
  3
  3
  5
  0
  5
  </code></pre>
  
  <p>I want to sort my fields , I need to return fields with not zero value first and when with zero value  , the sorted rows should look like this </p>
  
  <pre><code>1
  5
  2
  3
  3
  5
  5
  0
  0
  0
  </code></pre>
  
  <p>I don't whant to sort by number , I want to show 0 values at last , </p>
  
  <p>I've this code but it sort them by number  :</p>
  
  <pre><code> ORDER BY cASE WHEN num_mojud = 0 THEN num_mojud END ASC,CASE WHEN num_mojud &gt; 0 THEN num_mojud END ASC
  or
  ORDER BY IF (num_mojud = 0, 9999999, num_mojud )
  </code></pre>
  
  <p>how can I do so ? </p>