[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: How to do a Max in a sub query...

[arnieOag]

I figured out a way to do it:


  | from us.tx.state.oag.olrap.db.InfoApplication as apps
  | where apps.codeStatus.statusId = :codeStatus 
  |   and apps.infoWorkflows.emplid = :emplId 
  | group by apps.applicationId 
  | 	having apps.infoWorkflows.entryDate = max(apps.infoWorkflows.entryDate)
  | )
  | order by apps.createdDate asc
  | 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119075#4119075

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119075