select kh,xfrq,crje,xfje,count(*) from qd.db
group by kh,xfrq,crje,xfje
having count(*)=2
符合上述结果的SQL记录有900多条,
怎么把上述count(*)=2的记录将其标志(bz)改变为1、2
既:(意思)
update set bz=(1..2) from qs.db where
( select kh,xfrq,crje,xfje,count(*) from qd.db
group by kh,xfrq,crje,xfje
having count(*)=2 )
group by kh,xfrq,crje,xfje
having count(*)=2
符合上述结果的SQL记录有900多条,
怎么把上述count(*)=2的记录将其标志(bz)改变为1、2
既:(意思)
update set bz=(1..2) from qs.db where
( select kh,xfrq,crje,xfje,count(*) from qd.db
group by kh,xfrq,crje,xfje
having count(*)=2 )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货