how do i use count to sum ID numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've a lot of student IDs and i want to use count function to count how many
times a specific student number occurs.
If there's other smart ways you know please help me.
Thanks
Ralph.
 
You can do it like this:
SELECT DISTINCT StudentTable.StudentID, Count(StudentTable.StudentID) AS
[CountOfStudentID]
FROM StudentTable
GROUP BY StudentTable.StudentID;
 
Back
Top