select * from(
select a.id ,(select b.name from b where b.id=a.id) name,row_num() over (partition by dep order by add_date desc) rn
)
where rn=1;
关联表放在上边，做等值关联，分组会出问题
select a.id ,(select b.name from b where b.id=a.id) name,row_num() over (partition by dep order by add_date desc) rn
)
where rn=1;
关联表放在上边，做等值关联，分组会出问题
扫一扫
1835
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
