Originally posted by dhriti joshi: I guesss select max is not supported by ejbql. is there any way to do it,like get the entire collection of field and then find max. please help. thanks.
From what I know EJB-QL doesn't support max. I remember that I'd seen some ejb-ql extensions a while ago; but these will be vendor specific. What I'd do in this situation is use jdbc directly to execute select max... statement. Just make sure that you use jdbc connection pool.