title: DISTINCT TOP 10 on a Single Column
body: <p>The following SQL statement is not working, and I am not sure how to correct it:</p>
  
  <pre><code>select
      a0.TEST as TEST,
      count(DISTINCT TOP 10 a0.TEST_CLMN) as CC
  from 
      dbo.TESTING a0
  group by 
      TEST
  </code></pre>
  
  <p>If I remove TOP 10 it returns results, else I get </p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'TOP'.</p>
  </blockquote>
  
  <p>Is it possible to apply <code>DISTINCT</code> and <code>TOP 10</code> on a single column ?</p>
  
  <p>EDIT:
  DOES TOP 10 have to be after select ?</p>