How to find the Count of each value in a column in sql

hi,
 
here sample example query.
 
have column in table contains valies this
[column]
as,bs
as,cs
cs,es
de,as
ir,cs,de.
 
need find count of each value , output shuld come
5
bs 3
cs 4 .
 
can me write procedure
 

thanks,
anusha

---

thanks, anusha

hi anusha,

get belows -

http://www.c-sharpcorner.com/forums/thread/51227/

http://social.msdn.microsoft.com/forums/en-us/csharplanguage/thread/cdc05234-0c35-46d9-955d-441a0659b37a?persist=true

http://www.codeproject.com/articles/4416/beginners-guide-to-accessing-sql-server-through-c

---

pl. mark/proposed answer if found solution vote helpful if related topic. motivate others performing action.

Visual Studio Languages  ,  .NET Framework  >  Visual C#