22,209
社区成员
发帖
与我相关
我的任务
分享
;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