2022-08-01
閱讀量:
865
提取
select a.*,b.*,t.max_date
from user_log a
left join payment_log b on a.user_id=b.user_id and a.login_date=b.pay_date
left join (select a.user_id,MAX(a.login_date) as max_date from user_log a GROUP BY a.user_id) t on a.user_id=t.user_id
ORDER BY a.user_id,a.login_date;






評(píng)論(0)


暫無數(shù)據(jù)
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
1條評(píng)論
0條評(píng)論