update prodlist
set price=a.salary,date=a.begindate
from
(
select salary,pxid,max(begindate) as begindate from prodgx group by salary,pxid
)a
where prodlist.pxid=a.pxid
set price=a.salary,date=a.begindate
from
(
select salary,pxid,max(begindate) as begindate from prodgx group by salary,pxid
)a
where prodlist.pxid=a.pxid
set price= (select min(salary)
from prodgx T
where begindate = (select max(begindate)
from prodgx
where pxid = T.pxid)
and prodlist.pxid = T.pxid)
,[date]=(select max(begindate)
from prodgx
where pxid = prodlist.pxid)
set price = A.salary,
date = A.begindate
from prodgx as A
where prodlist.pxid = A.pxid
and A.begindate = (select max(begindate) from prodgx where id = A.id)
set price = a.salary,
[date] = a.begindate
from prodgx a inner join prodlist b
on a.pxid = b.pxid
and a.begindate = (select max(begindate) from prodgx where id = a.id)
=(select max(begindate) from prodgx where id = a.id) 的记录可能多条
set price = a.salary,
[date] = a.begindate
from prodgx a inner join prodlist b
on a.pxid = b.pxid
and a.begindate = (select max(begindate) from prodgx where id = a.id)