重生之各大厂争着抢我

分类

/ 注册

全部文章（共48篇）

题解 | 查询订单

select order_id,customer_name,order_date from ( select customer_id,max(order_date) as order_date from orders group by customer_id )temp jo...

2026-01-08

0 34

题解 | 每个部门薪资排名前两名员工

select department,employee_name,salary from( select department,employee_name,salary,row_number() over(partition by department order by salary desc...

2026-01-08

0 41

题解 | 商品销售总额分布

select pay_method,count(*) as numbers from( select case when trim(pay_method)='' then 'error' else pay_method end as pay_method from user_cli...

2026-01-08

0 39

题解 | 商品价格排名

with a as( select *, dense_rank() over(partition by type order by price desc) as rk from product_info ), b as( select * from a...

2026-01-08

0 42

题解 | 下单最多的商品

with a as( select product_id, count(*) as buy_count from user_client_log where step='order' group by product_id ), b as ( ...

2026-01-08

0 38

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

with a as( select exam_id, avg(timestampdiff(minute,start_time,submit_time)) as avg_time, avg(score) as avg_score from exam_record ...

2026-01-08

0 29

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

with a as( select room_id, count(distinct user_id) as user_count from user_view_tb where (in_time between '23:00:00' and '24:00:00') o...

2026-01-08

0 47

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

with a as( select cid, count(*) as view_number from play_record_tb group by cid,uid having count(*)>1 ), b as( select cid, ...

2026-01-08

0 44

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

select goods.*,total from ( select goods_id, sum(count) as total from trans group by goods_id having sum(count)>20 ) total_...

2026-01-08

0 57

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

with a as( select distinct music_id from ( select follower_id from follow where user_id=1) f join music_likes on f.follower_id=mu...

2026-01-08

0 44