How to get count of records group by a column

Hi ,

Could some one help to use the aggregate function count to get number of rows based on one particular column. For e.g something like below corresponding to sql.

select count(1),testcolumn from testtable group by testcolumn .

so i can get the records liks as below:

test1 100

test2 200

test3 300