title: Oracle query - how to make count to return values with 0
body: <p>How can I make a count to return also the values with 0 in it.</p>
  
  <p>Example:</p>
  
  <pre><code>select count(1), equipment_name 
  from   alarms.new_alarms 
  where  equipment_name in (
             select eqp from ne_db.ne_list)
  Group by equipment_name
  </code></pre>
  
  <p>It is returning only the counts with values higher than 0 , but I need to know the records that are not returning anything.</p>
  
  <p>Any help is greatly appreciated.</p>
  
  <p>thanks,</p>
  
  <p>Marco</p>