MySql Hibernate ²éѯÓï¾äÎÊÌâ

Java code:

select
mem.routId,
mem.memCode,
r.routName,
r.ipaddress,
min(mem.usedValue) as minUsedValue,
max(mem.usedValue) as maxUsedValue,
avg(mem.usedValue) as avgUsedValue
from Net_Cap_Mem mem, Net_Routinfo r
where mem.routId=r.routId and recordTime>='2010-03-04 16:56:56' and recordTime<='2010-03-08 15:29:26'
and mem.routId in (select plan.goId from Net_Gatherpublicobject plan where plan.gmId=2) group by mem.routId order by avgUsedValue desc





ÉÏÃæÊÇÒ»¸öMysql+Hibernate²éѯÓï¾ä
  ×îºóÎÒÏëÓà ×ֶΠavg(mem.usedValue) as avgUsedValue ÅÅÐò 
  ÎÊÌ⣺
  ÎÒ°ÑÕâÓï¾ä·ÅÈë´úÂëÖÐÖ´Ðоͱ¨´í£¡ËµÊÇÕÒ²»µ½ avgUsedValue Õâ¸ö×Ö¶Î
  Ö±½Ó·ÅÈë Êý¾Ý¿âÖпÉÒÔÕý³£²éѯµ½Êý¾Ý£¡


  ÕâÊÇÉÏÃæÎÊÌ⣬Ӧ¸ÃÔõô½â¾ö£¿£¿£¿£¿

---

ºÃÁË ½â¾öÁË£¡