0 Replies Latest reply on Oct 19, 2004 5:02 AM by madadi

    jboss-ql to get MAX value ...information needed

    madadi Newbie

      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:
      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.