今天offer拿到了吗

分类

/ 注册

全部文章（共18篇）

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from (select emp_no, birth_date, first_name, last_name, gender, hire_date, den...

2025-06-14

0 16

题解 | 更新员工信息表

with eu as (select EMPLOYEE_ID , UPDATE_DT, row_number() over(partition by EMPLOYEE_ID order by UPDATE_DT desc) as rk, NEW_POSITION from ...

2025-06-08

0 11

题解 | 商品价格排名

with t as(select product_id, product_name, type, price, dense_rank() over(PARTITION by type order by price desc) as rk from product_in...

2025-05-30

0 25

题解 | 完成员工考核试卷突出的非领导员工

select emp_id, emp_level, exam_tag from ( select emp_id, emp_level, exam_tag, start_time, submit_time, score from( select emp_id, emp_level, tag as ex...

2025-05-29

0 21

题解 | 被重复观看次数最多的3个视频

select cid, pv, rk from( select cid, max(release_date) as release_date, round(count(*)*1.0,3) as pv, row_number() over (order by count(*) ...

2025-05-29

0 27

题解 | 查询成绩

select count(*) from( select sId, avg(score) as avg_score from SC group by sId) t where avg_score > 60

2025-05-29

0 26

题解 | 商品交易(网易校招笔试真题)

select g.id, name, weight, sum(count) as total from goods g left join trans t on g.id = t.goods_id group by g.id having sum(count) >...

2025-05-29

0 30

题解 | 网易云音乐推荐(网易校招笔试真题)

select music_name from( select distinct(music_id), music_name from follow f left join music_likes ml on f.follower_id = ml.user_id left join m...

2025-05-29

0 23

题解 | 每天登陆最早的用户的内容喜好

select date(log_time) as log_day, user_id, hobby from ( select user_id, dense_rank() over(partition by date(log_time) order by log...

2025-05-29

0 19

题解 | 统计加班员工占比

select department, concat(round((sum(con)/count(con))*100,1), '%') as ratio from(select staff_id, department, case wh...

2025-05-29

0 34