how do i use count to sum ID numbers

G

Giftedmind

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

Klatuu

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