Hello,

Having mytable(id, begin_time, end_time, name) and the mapping file for it, can anyone tell me how a query that returns a list having (min(begin_time), max(end_time)) items would look like ?
So, it should return something like this:

results
---------------------
min(begin_time)
max(end_time)

Thanks!

Hi bhibernate!

Read here about aggregation
http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/queryhql.html#queryhql-aggregation

I think you can't get result as "list" - but it is not so hard to convert objects array to whatever you need.