how do i use count to sum ID numbers

[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.

 

[Guest]

You can do it like this:
SELECT DISTINCT StudentTable.StudentID, Count(StudentTable.StudentID) AS
[CountOfStudentID]
FROM StudentTable
GROUP BY StudentTable.StudentID;