Avg(...) aggregate function

[subhashchandra medhiassam]

Dear friends,
I would like to know how to use the avg(...) aggregate function available in hibernate. Kindly help me with some simple example.

Thanks in advance,
Subhash

[Sridhar Santhanakrishnan]

select avg(e.salary) from Employee e

[subhashchandra medhiassam]

Thanks. But i would like to know how to execute the query and retrieve the result of the avg(...) function. Kindly help.

Subhash

[Paul Sturrock]

Here is the best place to start. Have a read of the chapter on Querying.