Aki5

分类

/ 注册

全部文章（共12篇）

题解 | 查询连续登陆的用户

with user_login as ( select rt.user_id, lt.log_time, -- 取后一天的登录时间 lead(lt.log_time, 1) over(partition by rt.user_id order by lt.lo...

2025-08-15

0 33

题解 | 查询培训指定课程的员工信息

select staff_tb.staff_id, staff_name from staff_tb join cultivate_tb on staff_tb.staff_id = cultivate_tb.staff_id where right(course,1) = '3'

2025-08-14

1 22