title: Using countif in Oracle sql to calculate for each row
body: <p>Can i know is there any sql statment like in <code>Excel</code> <code>countif</code> to count high, medium and low which is based on condition.</p>
  
  <p>For instance, the table below shows on using countif in high we can see High how much, low how much and medium how much for each row</p>
  
  <pre><code>ID   Name     Value1     Value2     Value3    ValueN   High   Medium  Low
  ---  -------  ---------  ---------  --------  -------  -----  ------  ------
  1    A        High       High       Low       Medium   2      1       1 
  2    AB       Low        Medium     Low       High     1      1       2
  3    ABC      High       Low        Low       High     2      0       2
  </code></pre>