17,377
社区成员
发帖
与我相关
我的任务
分享
select AREAGUID,max(ddate) as maxddate,min(ddate) as minddate,max(METERNLLJ)-min(METERNLLJ) as MeterNLLJ,max(METERNLLJ) as aa,min(METERNLLJ) as bb from ( select AREAGUID from TWater where
(to_char(DDate,'yyyy-mm-dd')='2009-10-1' or to_char(DDate,'yyyy-mm-dd')='2009-10-30') and AreaGuid = 407) xx group by AREAGUID
select a.AREAGUID,--用户号
a.umax,--最大值
a.umin,--最小值
b.ddate umaxd,--最大值日期
c.ddate umind,--最小值日期
b.METERNLLJ-c.METERNLLJ umg --用量
from (select AREAGUID,max(METERNLLJ) umax,min(METERNLLJ) umin
from TWater
group by AREAGUID) a,
(select a.AREAGUID,a.METERNLLJ,a.ddate
from TWater a,
(select AREAGUID,max(ddate) ddate
from TWater
group by AREAGUID) b
where a.AREAGUID = b.AREAGUID
and a.ddate = b.ddate
) b,
(select a.AREAGUID,a.METERNLLJ,a.ddate
from TWater a,
(select AREAGUID,min(ddate) ddate
from TWater
group by AREAGUID) b
where a.AREAGUID = b.AREAGUID
and a.ddate = b.ddate
)c
where a.AREAGUID = b.AREAGUID
and a.AREAGUID = c.AREAGUID;