update proposal
set content=s.content
from proposal p,
(select p1.pname,
p1.content
from proposal p1,
(select pname,
min(no) as minno
from proposal
group by pname
) s1
where p1.no=s1.minno
) as s
where p.pname=s.pname
set content=s.content
from proposal p,
(select p1.pname,
p1.content
from proposal p1,
(select pname,
min(no) as minno
from proposal
group by pname
) s1
where p1.no=s1.minno
) as s
where p.pname=s.pname
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货