help with count() and group by

[kairog]

Hi all,

I want to get all rows from a table where entry for each ID equals 15

I tried this sql command:
select ID, count(ID) as count from IDentries group by ID

But it extracts all rows with total count for each ID.

I'm looking at only those ID's that are entered into the table 15 times. those ID's with less than 15 should not be fetched.

Any fitting sql statements?

Cheers,
Kairog :)

[PeaTearGriffin]

I think adding "HAVING count(ID) >= 15" to the end of your query should work.

[kairog]

Thank you PeaTearGriffin that perfectly fits! :)