title: List number of rows per field value in SQL
body: <p>database/SQL novice here.</p>
  
  <p>I have a table with a column called, for example, "EmployeeID". I want a query that will, for each distinct employeeID, return the number of rows that have that as their ID. I hope it's clear what I'm trying to do and someone will know how to help!</p>
  
  <p>I don't think it should matter, but just in case, I'm using MS SQL Server 2008.</p>