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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3851864#3851864 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3851864 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
