在努力的安哥拉兔很热爱生活

分类

/ 注册

全部文章（共3篇）

题解 | #得分不小于平均分的最低分#

with t as( select a.*,tag,avg(score) over(partition by a.exam_id) as avg_score from exam_record a left join examination_info b on a.exam_id = b.exam_...

2024-08-14

0 116

题解 | #查找最晚入职员工的所有信息#

select * from employees order by hire_date desc limit 1

2024-08-14

0 126

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

with t1 as ( select user_id,date(log_time) log_time,row_number()over(partition by user_id order by date(log_time)) as rk from login_tb gro...

2024-08-14

3 189