Help with a query

[limester]

I am trying to query a database where I have tbl1

I would like to count tbl1 and then return the distinct rows of clm1 tbl1.

For example, I have 10,000 entries in tbl1. clm1 represents a state so the output I am looking for is:

2,000 OH
4,000 CA
4,000 FL

Thanks!

 

[gmmastros]

You'll want to use group by. There are many aggregate functions at your disposal, each requiring a group by. Do a little research in Books On Line.

Select clm1,
       Count(*) As CountOfRecords
From   tbl1
Group By clm1
Order By clm1

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[limester]

Thanks gmmastros....I had just found the answer using group by, I swear!! : )

Thanks again!