I just find that in ejb2.1, ejb-ql have somenew function - AVG, COUNT...i wonder is it work in JBOSS?if not, how can i get something like'select count(*) from table'or 'select count(*) from table where ...'
check the CMP forum for info