Query limiting the counted records to certain amount 1

[BeachSandGuy]

Hi, I am attempting to have a query count many thousands of records. Results could look like the following from the following:
Select Day, Place, Count(RecordNumber) From Table
Group by Day, Place

Day | Place | Count
1 | AZ | 15
1 | CA | 20
1 | ID | 3
2 | AZ | 20
2 | CA | 10
2 | ID | 10

How can I write that query so it would on return those records that had counts >= 10, so the final results would look like:
Day | Place | Count
1 | AZ | 15
1 | CA | 20
2 | AZ | 20
2 | CA | 10
2 | ID | 10

Thanks for any help. Couldn't find the solution in the forum or google...

Ian

 

[gmmastros]

Right after your GROUP BY clause, add:

[tt]Having Count(Whatevercolumn) >= 10[/tt]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[BeachSandGuy]

Thank you, worked like a charm, learned something new!

Ian