Hi,

I'm newish to sql and i need to do a query but am not too sure how.

Say i have a table with a column called 'name' how could i count the number of different names in the table, ie have a result like:

Name Count
Alan 5
Steve 4
...

Where there would be 5 records in the table that had the name Alan and 4 with Steve...

Can someone please help me out here. Hope you know what i mean.

Thanks very much,
Alan.

Give this a try:

select name, count(*) from table
group by name