title: SQL Server subquery syntax
body: <p>When I run the query :</p>
  
  <pre><code>select count(*) from 
  (select idCover from x90..dimCover group by idCover having count(*) &gt; 1) 
  </code></pre>
  
  <p>I get the error :</p>
  
  <pre><code>Server: Msg 170, Level 15, State 1, Line 2
  Line 2: Incorrect syntax near ')'
  </code></pre>
  
  <p>How do I formulate this query correctly?</p>
  
  <p>I'm on SQL Server 2000</p>