count on group by

sme · **Joined:** Mon Mar 01, 2004 7:41 am **Posts:** 6

I'm trying to do something like this:

I've got a cat table, each cat can belong to a certain type of cat, I would like to do a select where I group by cat.type and also count the number of cats that belong to each type.

Has anyone done something like this before?

emmanuel · **Posted:** Mon Jun 14, 2004 12:47 pm

select count(cat), cat.type from Cat cat group by cat.type

sme · **Joined:** Mon Mar 01, 2004 7:41 am **Posts:** 6

Thank you. It's so simple and so powerfull, I love it!

newbie · **Joined:** Wed May 12, 2004 3:17 pm **Posts:** 11

i am in search of this kind of HQL...
i can get the results by giving the query as
"select count(cat), cat.type from Cat cat group by cat.type"..

but i want to get the results in console like...

CatType Counts
--------- --------
type1 5
type2 7
...
...

like this...

Collection cats = catImpl.getCatByQuery(catQry); // is it right here?
java.util.ArrayList aList = new java.util.ArrayList(cats );

System.out.println("CatType Counts");
System.out.println("--------- --------");

for(int o=0;o<aList.size();o++) {
//i can get the results here ...but not the values...
// i couldnt get those onjects/values here...
}

can anyone gimme a solution for this...

how to get the COUNT(*) and ONE PROPERTY in a single query?

any points and tips will be highly appreciated.

-NewBie(totally?)

emmanuel · **Posted:** Wed Jul 21, 2004 7:43 am

Please read this part of the doc
http://www.hibernate.org/hib_docs/reference/en/html_single/#manipulatingdata-scalarqueries