SELECT DISTINCT uid, MIN(user_level) over(partition by uid) as user_level FROM( SELECT t1.uid, t1.ovd_days, t2.ovd_days as ovd_days_config, t2.user_level FROM ( SELECT * FROM dwd_trd_loan_tb_dd WHERE dt='20241011' )t1, dim_ovd_config_dd t2 )t3 WHERE ovd_days<=ovd_days_config;
点赞 评论

相关推荐

no_work_no_life:深圳,充电宝,盲猜anker
点赞 评论 收藏
分享
牛客网
牛客企业服务