LeetCode(数据库)- 活跃用户 Myth丶恋晨 2022-09-14 09:29 119阅读 0赞 **题目链接:**[点击打开链接][Link 1] **题目大意:**略。 **解题思路:**如图所示解决方案此类题必杀技。 **AC 代码** ![图片.png][.png] WITH t1 AS(SELECT * FROM Logins GROUP BY id, login_date) SELECT DISTINCT t1_5.id, name FROM t1 t1_1 JOIN t1 t1_2 ON t1_1.id = t1_2.id AND DATEDIFF(t1_2.login_date, t1_1.login_date) = 1 JOIN t1 t1_3 ON t1_3.id = t1_2.id AND DATEDIFF(t1_3.login_date, t1_2.login_date) = 1 JOIN t1 t1_4 ON t1_4.id = t1_3.id AND DATEDIFF(t1_4.login_date, t1_3.login_date) = 1 JOIN t1 t1_5 ON t1_5.id = t1_4.id AND DATEDIFF(t1_5.login_date, t1_4.login_date) = 1 JOIN Accounts a ON a.id = t1_5.id ORDER BY t1_5.id [Link 1]: https://leetcode-cn.com/problems/customers-who-never-order/ [.png]: /images/20220828/feb3d12bd999467db665f62c7353f77b.png
还没有评论,来说两句吧...