Is it possible to return all distinct records in a column as well as count of each distinct records:

example: I have a column called sID which may contain duplicate ids.

SID COUNT
---- -------
K13R 1
K14R 2
K15R 1
K17T 4


I havent been able to figure how to use the count function with the distinct keyword. I am not sure if that is the right approach anyway.

All assistance will be greatly appreciated.