Dera all,
I want to get maximun value from a specific field from table. so i tried using jboss-ql ..
SELECT MAX(a.id) FROM UseridNumber as a
When I try to use this I get an error:
Error compiling ejbql:
org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered "MAX " at line 1, col 8.
Was expecting one of:
"DISTINCT "
"OBJECT "...
I am using jboss 3.2.1. Can anybody tell me what is
wrong here, I would appreciate a lot your help.
Regards
kiran