title: case statement returns multiple rows
body: <p>I want to return multiple rows in case statement. is it possible? or is there any alternate way to do it?</p>
  
  <pre><code>select 
     case 
        when 3 = 1 
            then (select orderid from order_master where noOfInstallment = installmentPaid) 
        else 
            (select orderid from order_master where noOfInstallment &lt;&gt; installmentPaid) 
     END
  </code></pre>
  
  <p>Both sub queries returns multiple rows. Now above query showing following error.</p>
  
  <blockquote>
    <p>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used
    as an expression.</p>
  </blockquote>