SQL server 2005

[sundaramoorthy b]

Hi to all, I have values in sql table like RollNumber ---------------- 101,102,103 ---------------- Now i need get count of this cell, how can i get????? anyone help me...... Thanks in advance......

[David Mujica]

select count(*),RollNumber from group by RollNumber remember to vote !

[UTHIRASAMY]

select count(firstField1),count(firstField2),count(firstField3)from tblname group by firstField1,firstField2,firstField3

[AshishChaudha]

comma (,) seperated rollno in a single field?? clarify please