Criteria Api groupby

[Thar]

Hi all,

I have a table which consists of Composite key made up of three columns . Let the columns be A,B,C .Now the situation is to have groupby on three combinations
1] A,B
2] A,C
3] A
Can this be done through multiple projections on single Criteria call. What are the other options.
Thanks in advance.

[Janos™]

I think that most of the databases let you have both an ORDER BY and a GROUP BY on a SELECT statement. For simple queries, such as grouping by department, but sorting by maximum salary in descending order, this might be sufficient. But, for more complex scenarios you will probably have to use a SubQuery. See the "From SubQuery" example in the SubQuery Showcase.