题解 | 输出在5min内完成点击购买的用户ID
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
select u1.user_id as uid from user_ad_click_time u1 inner join user_payment_time u2 on u1.user_id = u2.user_id and u1.trace_id = u2.trace_id where TIMESTAMPDIFF(minute,u1.click_time,u2.pay_time)<5
虾皮信息一面327人在聊
查看15道真题和解析
投递字节跳动等公司7个岗位 >