又被画饼了的牛可乐很热血
又被画饼了的牛可乐很热血
全部文章
分类
归档
标签
去牛客网
登录
/
注册
又被画饼了的牛可乐很热血的博客
全部文章
(共4篇)
题解 | 查询连续登陆的用户
SELECT DISTINCT r.user_id FROM register_tb r JOIN login_tb a ON r.user_id = a.user_id JOIN login_tb b ON r.user_id = b.user_id AND DATEDIFF(DATE(...
2025-07-07
1
81
题解 | 查询培训指定课程的员工信息
select s.staff_id,s.staff_name from staff_tb s join cultivate_tb c using(staff_id) where c.course like '%3%'
2025-07-04
2
65
题解 | 查询连续入住多晚的客户信息?
select c.user_id,c.room_id,g.room_type,datediff(c.checkout_time,c.checkin_time) days from checkin_tb c join guestroom_tb g using(room_id) where datedi...
2025-07-04
1
80
题解 | 最长连续登录天数
with fdate_rnk as ( select fdate,user_id,row_number()over(partition by user_id order by fdate) rnk from tb_dau where fdate between '2023-01-01' a...
2025-07-04
1
63