题解 | #输出在5min内完成点击购买的用户ID#
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
-- trace_id为主键 select t1.user_id as uid from user_ad_click_time t1 join user_payment_time t2 on t1.trace_id = t2.trace_id where timestampdiff(minute,t1.click_time, t2.pay_time) < 5 order by t1.user_id desc
查看7道真题和解析
投递百度等公司10个岗位 >