SELECT avg(fe) as mfe,avg(si) as msi,mdate,
and mdate BETWEEN :rq1 and :rq2
group by mdate在delphi ADOQuery中
如何用一句sql分别求出mfe 和 msi最大值这样不行,我试了
select Max(mfe),max(msi) from(
SELECT avg(fe) as mfe,avg(si) as msi,mdate,
and mdate BETWEEN :rq1 and :rq2
group by mdate
)、
and mdate BETWEEN :rq1 and :rq2
group by mdate在delphi ADOQuery中
如何用一句sql分别求出mfe 和 msi最大值这样不行,我试了
select Max(mfe),max(msi) from(
SELECT avg(fe) as mfe,avg(si) as msi,mdate,
and mdate BETWEEN :rq1 and :rq2
group by mdate
)、
SELECT avg(fe) as mfe,avg(si) as msi,mdate,
and mdate BETWEEN :rq1 and :rq2
group by mdate
) as a
group by mdate
,mgroup
from yalfx where mgroup=9
group by mdate,mgroup
) as a
高手,如何将mgroup赋值vv,
在ADOQuery的sql中语句如果改为mgroup=:vv,提示{不正常地定义参数对象}
,mgroup
from yalfx where mgroup='''+vv+'''
group by mdate,mgroup
) as a'