27,579
社区成员
发帖
与我相关
我的任务
分享
cdbl(ye)/cdbl(cq)*cdbl((month(jyrq)-month(khrq)+1))
JYRQ .select cdbl(ye)/cdbl(cq)*cdbl((select (month(jyrq)-month(khrq)+1)from hj where zhzt='清户'and zh='1111111111111111111111')) from(SELECT * from hj where zh in(select zh from hj where xz='整整'and dwbh like '001*'group by zh having count(*)>1)) where zh='1111111111111111111111'
加了条件SELECT lxh1, xm1, zh, ye1, jyrq1, khrq1, datediff("m",khrq1,jyrq1) AS yf1, cq1, format(cdbl(cdbl(ye1)/cdbl(cq1)*(yf1)),"0.00") AS jf
FROM
(SELECT min(lxh) as lxh1,min(xm) as xm1,zh,max(ye) as ye1,max(format(jyrq,"yyyy-mm-dd")) as jyrq1,min(format(khrq,"yyyy-mm-dd")) as khrq1,max(cq) as cq1 from hj
where cq<>'0' and zhzt in('正常','清户','自转')
group by zh
having count(*)>1
)
select cdbl(ye)/cdbl(cq)*cdbl((month(jyrq)-month(khrq)+1))
from hj where zh in(
select zh from hj where xz='整整'and dwbh like '001*' group by zh having count(*)>1)