Hello,
I'm so confused with Group By using Criteria by reading tips/articles on the internet,
so I hope someone can help me here...

I have a table:
City, Name, Donation
------------------------
Jakarta, Helen, $20
Jakarta, Boy, $5
Jakarta, Helen, $10
Bandung, Rudy, $3
Bandung, Linda, $4

I can group by the City and sum the Donation so that the table like this:
City, Donation
----------------
Jakarta, $35
Bandung, $7

but I don't know how to group by the Name and sum Donation, so that the table will be like this:
City, Name, Donation
------------------------
Jakarta, Helen, $30
Jakarta, Boy, $5
Bandung, Rudy, $3
Bandung, Linda, $4

(I can group by the Name, but the City doesn't come up)
please help,
Faizal

Hi !

You have to group by the City and the Name in order to have the same result.

something like :

select t.city, t.name, sum(t.donation)
from yourtable as t
group by t.city, t.name

Hi try this criteria

Criteria crit = session.createCriteria(ForumBeanValue.class)
.setProjection(
Projections.projectionList()
.add(Projections.groupProperty("city"))
.add(Projections.groupProperty("name"))
.add(Projections.sum("donate"))

);

Hello all, thanks for your replies,
what if my table is like this:

City, Name, Donation
------------------------
Jakarta, Helen, $20
Jakarta, Boy, $5
Jakarta, Helen, $10
Bandung, Rudy, $3
Bandung, Linda, $4
Bandung, Helen, $6

and I want to group by Name and sum Donation, so I can have the result like this:

City, Name, Donation
------------------------
Jakarta, Helen, $30
Jakarta, Boy, $5
Bandung, Rudy, $3
Bandung, Linda, $4
Bandung, Helen, $6

as the result I want above, the City is not grouped for Name Helen

can I do this using Criteria?