Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 考试分数(五)

with median_rows as(select job, floor((count(*)+1)/2) as start_row, floor((count(*)+2)/2) as end_row from grade group by job) select ...

2025-06-26

0 43

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 38

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 56

题解 | 考试分数(四)

select distinct job, case when (count(*) over(partition by job))%2=1 then round(((count(*) over(partition by job))-1)/2+1,0) else round(((...

2025-06-26

0 34

题解 | 考试分数(三)

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

2025-06-26

0 39

题解 | 考试分数(二)

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

2025-06-26

0 53

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

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 36

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

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

2025-06-25

0 49

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

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 51

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

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 62