热血的小山竹在加班

分类

/ 注册

全部文章（共14篇）

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

with a as( SELECT dept_emp.*, salary as emp_salary ##计算员工及其薪资情况 FROM dept_emp LEFT JOIN salaries ...

2025-04-01

0 80

题解 | 每个顾客购买的最新产品名称

with a as ( select *, dense_rank() over(partition by customer_id order by order_date desc) as drk from orders o left join ...

2025-04-01

0 67

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

select t.emp_id, t.emp_level, t.tag as exam_tag from ( SELECT exam_record.*, examination_info.tag, ...

2025-04-01

0 66

题解 | 查询成绩

select count(*) FROM ( SELECT DISTINCT AVG(score) over ( partition by sid ...

2025-03-31

0 69

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

with t1 as ( select goods_id, sum(count) as total from trans group by good...

2025-03-31

0 56

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

with t as ( select distinct date (log_time) as log_day, user_id, rank() over ( partiti...

2025-03-31

0 56

题解 | 查询单日多次下订单的用户信息？

with t as ( select distinct date (order_time) as order_date, user_id, count(order_id) over ( ...

2025-03-31

0 67

题解 | 查询单日多次下订单的用户信息？

with t as ( select distinct date (order_time) as order_date, user_id, count(order_id) over ( ...

2025-03-31

0 78

题解 | 更新用户积分信息？

with t as( select user_id, sum(order_price) as ad from order_tb where order_price>100 group by user_id ) select use...

2025-03-31

1 70

题解 | 统计用户从访问到下单的转化率

select date(visit_time) as date, concat(round(count(distinct o.user_id)*100 / count(distinct v.user_id),1),'%') as cr from visit_tb v left join order...

2025-03-31

0 70