title: Select Count Query Giving Inaccurate Results
body: <p>I'm trying to query the table CANCELLATION_DEFINITION, and count the amount of rows that have an ACTION_TYPE value that isn't "-". Unfortunately, the query is giving me inaccurate results. For example, it returns 3 for this table when there are 6 rows in the table that have an ACTION_TYPE value other than "-". Code is below.</p>
  
  <pre><code>SELECT COUNT(*) 
  FROM    (
       SELECT DISTINCT 
       ACTION_TYPE
       FROM CANCELLATION_DEFINITION WHERE ACTION_TYPE != '-'
       )AS distinctified  
  </code></pre>