title: The definite number of the rows as per the definite parameters in SQL
body: <p>I need to get all rows if number is NULL or to get number rows.</p>
  
  <p>This is my code so far.</p>
  
  <pre><code>  CASE
     WHEN value IS NOT NULL THEN SELECT FIRST number * FROM MYTABLE
    END
  </code></pre>
  
  <p>What is the best way to do it?</p>