title: SELECT COUNT(*) SQL SERVER
body: <p>I have this:</p>
  
  <pre><code>SELECT AssignmentID
  FROM ProblemView
  GROUP BY AssignmentID
  </code></pre>
  
  <p>which returns 32 rows.
  But really what I want is the number 32.
  If I do this: </p>
  
  <pre><code>SELECT COUNT(*)
  FROM lru.ProblemView
  GROUP BY AssignmentID
  </code></pre>
  
  <p>I still get 32 rows, and the column is merely the count of the number of Assignments per problem.</p>
  
  <p>I just need the number 32.</p>