title: Count of Distinct Rows Without Using Subquery
body: <p>Say I have Table1 which has duplicate rows (forget the fact that it has no primary key...)  Is it possible to rewrite the following without using a JOIN, subquery or CTE and also without having to spell out the columns in something like a GROUP BY?</p>
  
  <pre><code>SELECT COUNT(*)
  FROM (
      SELECT DISTINCT * FROM Table1
  ) T1
  </code></pre>