Left_hidden的博客

原创 mysql

select * from (select * from t1 where dt = ‘20220709’ and … group by vid) a left join (select * from t2 where dt = ‘20220709’ and … group by vid) b on a.vid = b.vid left join (select t.* from (select *,row_number() over(partition by vid order by time) rn f