Lateral

分类

/ 注册

全部文章（共102篇）

题解 | 考试分数(三)

select t2.id, t2.name, t2.score from (select t1.id, t1.name, t1.score, dense_rank() over(partition by ...

2025-06-26

0 10

题解 | 考试分数(二)

select t.id, t.job, t.score from (select id, job, score, case when score>avg(score) ove...

2025-06-26

0 8

题解 | 牛客每个人最近的登录日期(六)

select t1.name as u_n, t2.date as date, coalesce(t2.num, 0) as ps_num from user t1 inner join (select user_id, date, ...

2025-06-26

0 11

题解 | 牛客每个人最近的登录日期(五)

with newdetail as( select user_id, date, case when row_number() over(partition by user_id order by date asc)...

2025-06-25

0 16

题解 | 牛客每个人最近的登录日期(四)

select t1.date, sum(if_new) as new from (select l.user_id, l.date, case when row_number() over(partition by l...

2025-06-25

0 14

题解 | 牛客每个人最近的登录日期(三)

select round(count(distinct t2.user_id)/count(distinct t1.user_id),3) as p from (select user_id,date from login)t1 left join (select user_id,date from...

2025-06-24

0 20

题解 | 牛客每个人最近的登录日期(二)

with t1 as (select u.name as u_n, c.name as c_n, l.date, l.user_id from login l left join client c on l.client_id=c.id left join...

2025-06-23

0 20

题解 | 异常的邮件概率

with t3 as(select t1.email_id, t1.send_id,t1.ifsendblack, t2.receive_id,t2.ifreceiveblack, t2.type,t2.date from (select e.id as email_id, e.send_id,u....

2025-06-13

0 18

题解 | 刷题通过的题目排名

select *, dense_rank() over(order by number desc) as t_rank from passing_number

2025-06-06

0 18

题解 | 出现三次以上相同积分的情况

select t3.number from (select t1.number, count(*) as cnt from grade t1 join grade t2 where t1.number=t2.number and t1.id<...

2025-06-06

0 16