Brain loss causes bad query 1

[Sleidia]

Hello,

Doing less and less mysql until recently, I just had the bad surprise to discover that there are some basic stuff that have escaped from my brain during all this time ;(

For exemple, I can't remember how to do this with a single query :

I have one table such as

category | objects
-------------------
A | 1
B | 2
A | 3
B | 4
A | 5
B | 6
A | 7
-------------------

I need to return the following sentence :
Category A has 4 items and category B has 3 items and ...etc ...

Note that categories aren't fixed.

Thanks so much

 

[r937]

[tt]select category
, count(*) as objects
from onetable
group
by category[/tt[

rudy

http://r937.com/

SQL Consulting

 

[Sleidia]

Oh my god ... that's wonderful ! Thanks !

I was mislead by thinking that COUNT would retrieve the rows within the scope of the GROUP BY function.

Many many thanks!
Have a nice day