Select clause in HQL

pragatiredkar · **Joined:** Tue Oct 02, 2007 1:47 am **Posts:** 6

HQL for select clause that contains :

1. columns
2. count(columnname) - to hold value of total records selected by the query.
3. sum(columnname) - to hold summation of value for all the records for the specified column name.

Can a HQL, serve this purpose ? How does the HQL look like in this case?

Thanks,

mmerder · **Posted:** Thu Feb 19, 2009 8:46 am

It could be like:

Code:

select propertyOne, propertyTwo, count(*), sum(propertyThree) from MyEntity group by propertyOne, propertyTwo

Notice: if you execute this query no Entity but a List of Arrays.
Do I understand your usecase right? You also want the aggregates to be grouped by the selected columns?