title: Alternative for count distinct
body: <p>I want an alternative way to write the following query</p>
  
  <pre><code>SELECT COUNT(DISTINCT col1) FROM table. 
  </code></pre>
  
  <p>I dont want to use <code>distinct</code>. Is there an alternative way?</p>