22,300
社区成员




;with cte as (
select wlbh,gg,bb,row_number() over (partition by wlbh order by bb desc) as number from B
)
select A.*,cte.gg,cte.bb from A
left join cte on cte.wlbh = A.wlbh
where cte.number = 1
有个字符打错了
;with cte as (
select wlbh,gg,bb.row_number() over (partition by wlbh order by bb desc) as number from B
)
select A.*,cte.gg,cte.bb from A
left join cte on cte.wlbh = A.wlbh
where cte.number = 1