牛客907689258号
牛客907689258号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客907689258号的博客
全部文章
(共28篇)
题解 | 对所有员工的薪水按照salary降序进行1-N的排名
SELECT emp_no, salary, DENSE_RANK() OVER ( ORDER BY salary DESC ) AS salary_rank FROM salaries WHERE to_date = '9999-01-01' OR...
2026-01-18
0
20
题解 | 获取所有非manager员工当前的薪水情况
SELECT de.dept_no, de.emp_no, s.salary FROM dept_emp de LEFT JOIN dept_manager dm ON de.emp_no = dm.emp_no JOIN salaries s ON de.e...
2026-01-18
0
15
题解 | 分析每个商品在不同时间段的销售情况
SELECT product_id, p.product_name, SUM( CASE WHEN o.order_date BETWEEN '2024-04-01' AND '2024-06-30' THEN o.total_amount E...
2026-01-14
0
17
题解 | 统计每个产品的销售情况
WITH order_full_cte AS ( SELECT * FROM orders o LEFT JOIN customers c USING (customer_id) LEFT JOIN products p...
2026-01-14
0
19
题解 | 请写出计算粉丝ctr的sql语句
select sum(read_num)/sum(show_num) as fans_ctr from a join b using(author_id) join c using(content_id, fans_id)
2026-01-14
0
21
题解 | 更新用户积分信息?
SELECT o.user_id, point + SUM(order_price) AS point FROM order_tb o JOIN uservip_tb u ON o.user_id = u.user_id WHERE order_price > 100 GRO...
2026-01-14
0
12
题解 | 未完成试卷数大于1的有效用户
WITH t AS ( SELECT r.uid, CONCAT(DATE(r.start_time), ':', i.tag) AS detail_item, CASE WHEN r.submit_time IS NULL THEN 1 EL...
2026-01-13
0
19
题解 | 牛客直播各科目出勤率
WITH merged AS ( SELECT b.user_id, c.course_name, b.course_id, b.if_vw, b.if_fav, b.if_sign, ...
2026-01-12
0
15
首页
上一页
1
2
3
下一页
末页