On Nov 25, 2003, at 10:33 PM, Bill Burke wrote:
Unfortunately EJB QL only allows 1 item in the select statement so no GROUP BY. Use Hibernate.
Even then GROUP BY on one table is useful. For example to change this:
UserId LocationId LastLoginDate 1 1 2003-01-01 1 1 2003-01-10 1 1 2003-01-12 1 2 2003-02-01 1 2 2003-03-12 2 1 2003-03-03 2 1 2003-04-05
into this:
UserId LocationId LastLoginDate 1 2 2003-03-12 2 1 2003-04-05
using something like:
select * from Blah group by LocationId order by Date desc;
There is no easy way to do this without GROUP BY.
S.
------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
