update a set a.isold='1' from cg_bzjgk a
--select count(*) from cg_bzjgk a
where
a.djh in(select djh from cg_bzjgk b where b.chdm=a.chdm and b.dqh=a.dqh and b.dwdm=a.dwdm)
--and a.chdm='MG-06-002'
and a.djh not in
(
select top 1 djh from cg_bzjgk c where c.chdm=a.chdm and c.dqh=a.dqh and c.dwdm=a.dwdm
order by c.rq desc,djh desc
) --3
update a set a.isold='0' from cg_bzjgk a
--select count(*) from cg_bzjgk a
where
a.djh in(select djh from cg_bzjgk b where b.chdm=a.chdm and b.dqh=a.dqh and b.dwdm=a.dwdm)
--and a.chdm='MG-06-002'
and a.djh in
(
select top 1 djh from cg_bzjgk c where c.chdm=a.chdm and c.dqh=a.dqh and c.dwdm=a.dwdm
order by c.rq desc,djh desc
) --266


select count(*) from cg_bzjgk


执行的结果,时而是两条影响数据,时而是一条,而且网络里显示不出结果
select count(*) from cg_bzjgk 是有结果的.
如果把第二条语句.就是那个注释--select count(*) from cg_bzjgk a
放到第一行的话.就显示正常了.然后再改回来.也显示正常.
是咋回事?